Search found 6 matches
- Fri Nov 09, 2018 3:07 pm
- Forum: Vertica SQL Functions
- Topic: MAPLOOKUP / MapJSONExtractor relative slowness
- Replies: 0
- Views: 59850
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...
- Thu Apr 26, 2018 9:18 am
- Forum: Vertica Performance Tuning
- Topic: Vertica not choosing the best projection for join?
- Replies: 0
- Views: 15714
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...
- Tue Apr 11, 2017 11:33 am
- Forum: Vertica SQL Functions
- Topic: TO_TIMESTAMP_TZ from string containing the UTC offset
- Replies: 4
- Views: 23065
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...
- Mon Apr 10, 2017 1:52 pm
- Forum: Vertica Data Load
- Topic: Parse Json from Vertica VARCHAR column
- Replies: 3
- Views: 21380
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 ...
- Mon Apr 10, 2017 1:45 pm
- Forum: Vertica SQL Functions
- Topic: TO_TIMESTAMP_TZ from string containing the UTC offset
- Replies: 4
- Views: 23065
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 ...
- Wed Mar 29, 2017 1:33 pm
- Forum: Vertica Data Load
- Topic: Parse Json from Vertica VARCHAR column
- Replies: 3
- Views: 21380
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...