Search found 302 matches
- Mon Jul 25, 2016 12:30 pm
- Forum: General
- Topic: Vertica Query returns zero records and when re-run returns some records
- Replies: 2
- Views: 7606
Re: Vertica Query returns zero records and when re-run returns some records
> Rows that are being returned are most likely not yet purged. Rows that have been deleted won’t be returned in the result set. SELECT statements default to being executed on the latest epoch, which won’t include the deleted records. Whether or not deleted records have been purged is irrelevant, sin...
- Sun Jun 19, 2016 9:11 pm
- Forum: Vertica SQL
- Topic: projection_usage table not all tables got query_start_timestamp
- Replies: 2
- Views: 17382
Re: projection_usage table not all tables got query_start_timestamp
Systems tables are really views on top of Data Collector tables. So the time span for the data in the system table is dependent upon the retention of the data in the DC tables. You can see the current effective retention for each table on each node in the DATA_COLLECTOR table. You can increase the r...
- Mon Jun 13, 2016 11:07 pm
- Forum: Vertica SQL
- Topic: Named value pair data in VARCHAR
- Replies: 1
- Views: 14008
Re: Named value pair data in VARCHAR
Already answered in the HP Vertica Community.
- Fri Apr 22, 2016 1:21 pm
- Forum: Vertica Database Administration
- Topic: Recommended AWS Instance Type for Vertica???
- Replies: 5
- Views: 12496
- Fri Apr 01, 2016 1:26 pm
- Forum: Vertica Performance Tuning
- Topic: Output Queue Wait(us) - Execution Engine Profiles
- Replies: 2
- Views: 17113
Re: Output Queue Wait(us) - Execution Engine Profiles
Hi Janica,
There is probably some other operator that has a long "clock time (us)" counter_value in the execution_engine_profiles data. You can correlate the profiling data to the explain plan using the path ids.
--Sharon
There is probably some other operator that has a long "clock time (us)" counter_value in the execution_engine_profiles data. You can correlate the profiling data to the explain plan using the path ids.
--Sharon
- Mon Mar 07, 2016 1:52 pm
- Forum: New to Vertica
- Topic: JSON datatype like MSSQL Server?
- Replies: 3
- Views: 22573
Re: JSON datatype like MSSQL Server?
One clarification on the previous reply. That example isn’t using a flex table - it’s a CREATE TABLE rather than CREATE FLEX TABLE. It’s creating a vmap for the json, and using the MAP functions to access it. Creating a flex table gives you more transparent mechanisms for accessing the json keys as ...
- Mon Feb 22, 2016 9:33 pm
- Forum: General
- Topic: Usage of AT EPOCH LATEST in VIEW
- Replies: 7
- Views: 15679
Re: Usage of AT EPOCH LATEST in VIEW
So then AT EPOCH LATEST is already effectively in use with READ COMMITTED - no need to use that. It would be worth understanding the actual source of the slowdown when you have the CDC running. Using AT EPOCH LATEST isn’t the solution.
—Sharon
—Sharon