Search found 4 matches

by _pj_
Tue Apr 11, 2017 11:33 am
Forum: Vertica SQL Functions
Topic: TO_TIMESTAMP_TZ from string containing the UTC offset
Replies: 4
Views: 433

Re: TO_TIMESTAMP_TZ from string containing the UTC offset

Hi, JimKnicely Thanks for your reply. In general you have posted then the same query that I provided in the initial post. Just that the output differs due to the fact that your database has different timezone. Mine has: >> show timezone /* name setting timezone Europe/Tallinn */ This is then UTC+2ho...
by _pj_
Mon Apr 10, 2017 1:52 pm
Forum: Vertica Data Load
Topic: Parse Json from Vertica VARCHAR column
Replies: 3
Views: 680

Re: Parse Json from Vertica VARCHAR column

Hi, Sharon Great reply, thank you. Seems to work from the functional point of view, from performance point of view it is still better to use ETL tool for the parsing as it seems to do it a lot faster. Not sure, but assume that it is related to the fact that we have the Json in Varchar(65000) column ...
by _pj_
Mon Apr 10, 2017 1:45 pm
Forum: Vertica SQL Functions
Topic: TO_TIMESTAMP_TZ from string containing the UTC offset
Replies: 4
Views: 433

TO_TIMESTAMP_TZ from string containing the UTC offset

Hi, All In Oracle you have the TZH(timezone hours) pattern one can use to convert string containing the timestamp and offset to the needed value. Could not find this for Vertica. Is it there? Any example of it. The way I tried it and could not get it to work: SELECT SOME_DATE AS SOME_DATE_AS_STRING ...
by _pj_
Wed Mar 29, 2017 1:33 pm
Forum: Vertica Data Load
Topic: Parse Json from Vertica VARCHAR column
Replies: 3
Views: 680

Parse Json from Vertica VARCHAR column

Hi, We have the case that Json is pushed from outer system to our Vertica database into tables with VARCHAR(65000) columns. We do not have any possibility to change this process currently. So to parse the Json-s we load those to our ETL tool, do the parsing there and then write back to the same data...

Go to advanced search