Hibiki
Employee
Hibiki Employee
Principal Product Technology Engineer, Vertica
Reactions
-
Re: Exporting access policy
It was implemented in 11.0.0. https://www.vertica.com/docs/11.0.x/HTML/Content/Authoring/NewFeatures/11.0/11.0.0/SQLandFunctions.htm#2 (View Post)1 -
Re: Commission custom User Defined Functions?
@Pieter_Sheth-Vo Does the following query with EXPLODE work as the workaround? => SELECT variance(value) FROM (-> SELECT explode(ARRAY[1, 2, 3, 4]) OVER(PARTITION BEST)-> ) a; variance------… (View Post)1 -
Re: Optimizing DISTANCE using projections
Please collect the query profile by using PROFILE clause. PROFILESELECT Date_trunc('month', modified_date), APPROXIMATE_COUNT_DISTINCT(userId) AS distinct_user_countFROM mySchema.userProjectionWHERE … (View Post)1 -
Re: How to set up to date vertica's projection data?
Have you already inserted the data into the table before creating the projections? If so, please run the following statement. => SELECT REFRESH('table name'); or => SELECT START_REFRESH(); http… (View Post)1 -
Re: Why is the error occured?? When I use ALTER VIEW view1 INCLUDE SCHEMA PRIVILEGES;
You can see the following description about GRANTS table. https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/GRANTS.htm For inherited privileges inform… (View Post)1