Search found 13 matches

by sKwa
Tue Jan 23, 2018 12:50 am
Forum: New to Vertica
Topic: Run VSQL under CygWin?
Replies: 6
Views: 598

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: 598

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: 232

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: 336

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: 142

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 ...
by sKwa
Wed Aug 23, 2017 7:09 pm
Forum: New to Vertica
Topic: Grouping Millis by Date and Hour
Replies: 2
Views: 304

Re: Grouping Millis by Date and Hour

Hi! dbadmin=> select dbadmin-> mill, dbadmin-> to_timestamp(mill / 1000) as ts, dbadmin-> to_char(to_timestamp(mill / 1000), 'YYYY-MM-DD HH24:MI') as yh dbadmin-> from ts; mill | ts | yh ---------------+-------------------------+------------------ 1484261834099 | 2017-01-13 00:57:14.099 | 2017-01-13...

Go to advanced search