Sudhakar_B
✭✭
Sudhakar_B ✭✭
Reactions
-
Re: Export To S3 And External table
@reli Yes, you are correct. parquet format file can be partitioned and external tables defined in Vertica on parquet or ORC can use "hive_partition" in the external table definition. It wil… (View Post)1 -
Re: Export To S3 And External table
@reli , AFAIK, you can't and don't need to created partitioned external table in Vertica. You can create normal external table with copy. Your COPY definition statement can use wildcards (globs) to m… (View Post)1 -
Re: Projections Hints
No worries @reli , So the PROJS hint in your case worked as expected or is it still an issue? Also, both projections have all the data correct? If you created the projection after data has been loade… (View Post)1 -
Re: Vertica 9.3 Supports UPDATE and DELETE Operations on Tables Having Live Aggregate Projections!
THANK YOU Jim! This was one of the MAIN reason at my customer site's, I was not able to use LAPs. LAPs are awesome, and I used to end up implementing "poor mans" LAP by building pre-aggrega… (View Post)1