Search found 15 matches
- Tue Feb 13, 2018 12:18 am
- Forum: Vertica SQL
- Topic: @@Rowcount
- Replies: 9
- Views: 37083
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 ...
- Mon Feb 12, 2018 9:21 pm
- Forum: Vertica SQL
- Topic: @@Rowcount
- Replies: 9
- Views: 37083
Re: @@Rowcount
Hi!
2. type of HDFS connector?
@micha0341. Vertica version?
2. type of HDFS connector?
- Tue Jan 23, 2018 12:50 am
- Forum: New to Vertica
- Topic: Run VSQL under CygWin?
- Replies: 6
- Views: 29439
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
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
- Sun Jan 21, 2018 5:54 pm
- Forum: New to Vertica
- Topic: Run VSQL under CygWin?
- Replies: 6
- Views: 29439
Re: Run VSQL under CygWin?
Hi!
find a difference in commands(HINT: chop vs chcp)
JimKnicely wrote: ↑Thu Jun 08, 2017 3:01 pmI installed Cygwin on Windows 7. I edited thec:\cygwin64\bin\cygwin1.batfile and added the following lines:
cmd.exe /c chcp 1252 set CYGWIN=binmode ntsec
find a difference in commands(HINT: chop vs chcp)
- Wed Aug 30, 2017 11:41 pm
- Forum: General
- Topic: dimensional data modelling design - Data warehouse
- Replies: 1
- Views: 29450
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...
- Wed Aug 30, 2017 11:25 pm
- Forum: Vertica User Defined Functions (UDFs)
- Topic: How can I execute my UDF paralliazing
- Replies: 1
- Views: 43146
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. ...
- Sat Aug 26, 2017 12:24 am
- Forum: Vertica User Defined Functions (UDFs)
- Topic: Row to JSON
- Replies: 0
- Views: 14889
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 ...