Search found 15 matches

by sKwa
Tue Feb 13, 2018 12:18 am
Forum: Vertica SQL
Topic: @@Rowcount
Replies: 9
Views: 3541

Re: @@Rowcount

Hi! 1. do COPY with no COMMIT 2. with same cursor/statement run "select get_num_accepted_rows() as 'ACCEPTED', get_num_rejected_rows() as 'REJECTED';" 3. observe results and commit or rollback Statement stmt = conn.createStatement(); stmt.execute("COPY ... FROM ..."); rs = stmt.executeQuery("select ...
by sKwa
Mon Feb 12, 2018 9:21 pm
Forum: Vertica SQL
Topic: @@Rowcount
Replies: 9
Views: 3541

Re: @@Rowcount

Hi!
@micha034
1. Vertica version?
2. type of HDFS connector?
by sKwa
Tue Jan 23, 2018 12:50 am
Forum: New to Vertica
Topic: Run VSQL under CygWin?
Replies: 6
Views: 1676

Re: Run VSQL under CygWin?

Hi!

It can be a problem with environment, so lets check it first - with CygWin install psql and try connect to Vertica with psql(yes, Vertica based on PostgreSQL and psql can connect to Vertica).

**PS**: https://stackoverflow.com/questions/144 ... -in-cygwin
by sKwa
Sun Jan 21, 2018 5:54 pm
Forum: New to Vertica
Topic: Run VSQL under CygWin?
Replies: 6
Views: 1676

Re: Run VSQL under CygWin?

Hi!
usao wrote:
Thu Jan 18, 2018 8:20 pm
When it tries to run the "chop" command, it sais that it doesn't exist.
JimKnicely wrote:
Thu Jun 08, 2017 3:01 pm
I installed Cygwin on Windows 7. I edited the
c:\cygwin64\bin\cygwin1.bat
file and added the following lines:
cmd.exe /c chcp 1252
set CYGWIN=binmode ntsec

find a difference in commands(HINT: chop vs chcp)
by sKwa
Wed Aug 30, 2017 11:41 pm
Forum: General
Topic: dimensional data modelling design - Data warehouse
Replies: 1
Views: 557

Re: dimensional data modelling design - Data warehouse

Hi! Should I add average_sales column in fact table... No, you should not. using the membership card should I add corresponding field in fact table? No, you should not. My understanding so far is only countable measures should be in fact table so I guess membership_card should not come in fact table...
by sKwa
Wed Aug 30, 2017 11:25 pm
Forum: Vertica User Defined Functions (UDFs)
Topic: How can I execute my UDF paralliazing
Replies: 1
Views: 1069

Re: How can I execute my UDF paralliazing

Hi! Not enough info, at least can you describe what it do, type of function (Scalar/Aggregate/Analytic/Transform), language (Python/Java/C++/R)? For example R do not supports parallelization (functions with recursion too). Also it can be a problem in implementation, so source code is also required. ...
by sKwa
Sat Aug 26, 2017 12:24 am
Forum: Vertica User Defined Functions (UDFs)
Topic: Row to JSON
Replies: 0
Views: 347

Row to JSON

Hi! Just for fun I wrote a function that converts row to JSON format. Source code is here Example: dbadmin=> select * from T; id | flag | date | str ----+------+------------+---------------------------------- 1 | t | 1970-01-01 | some string 2 | | 2017-01-01 | Invalid input syntax for integer 3 | f ...

Go to advanced search