Search found 6 matches

by _pj_
Fri Nov 09, 2018 3:07 pm
Forum: Vertica SQL Functions
Topic: MAPLOOKUP / MapJSONExtractor relative slowness
Replies: 0
Views: 59362

MAPLOOKUP / MapJSONExtractor relative slowness

Hi, All We have the case that Json is pushed from outer system to our Vertica database into tables with longvarchar columns. We do not have any possibility to change this process currently. In general the Jsons are simple linear ones, so we could in theory just parse those with MAPLOOKUP/MapJSONExtr...
by _pj_
Thu Apr 26, 2018 9:18 am
Forum: Vertica Performance Tuning
Topic: Vertica not choosing the best projection for join?
Replies: 0
Views: 15152

Vertica not choosing the best projection for join?

hi we have one table T1, and 4 projections on it P1..P4. P1 is basically only there to filter by ID1 (segmented and ordered by it) and returning only ID1 and ID2. P2 is segmented and ordered by ID2. Now if we query T1 by ID1 and join T1 alias T1_2 by ID2 then the query is fast enough for us (less th...
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: 22143

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

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

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

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