The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Delay in refreshing Tableau 8.0
hi, We are facing performance issues when using Tableau 8.0 with Vertica Analytic Database v6.0.1-4. Every time a user hits refresh on a work book in live mode, it runs the following query to fetch entire catalog from the database. Since queries by normal database users against catalog tables are slow in Vertica 6.0(known issue fixed in 6.1 I believe), it takes several minutes to refresh a work book. But the query to fetch the actual data takes only a few seconds. (select * from (select 'xxxxx' as catalog_name, vs_projections.schemaname as schema_name, vs_projections.anchortablename as table_name, null as non_unique, null as index_qualifier, null as index_name, 0 as type, null as ordinal_position, null as column_name, null as asc_or_desc, ROUND(AVG(total_row_count - deleted_row_count)) as cardinality, null as pages, null as filter_condition from vs_projections join storage_containers on vs_projections.name = storage_containers.projection_name group by vs_projections.schemaname, vs_projections.anchortablename order by non_unique, type, index_qualifier, index_name, ordinal_position) as vmd where catalog_name ilike E'mercury' escape E'\\' and schema_name ilike E'v_monitor' escape E'\\' and table_name ilike E'sessions' escape E'\\') Thanks D Note: This topic was created from a reply on the Problem in connecting vertica with tableau topic.