Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
- Last Active
- User Role
- Vertica Customer
@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
@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
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
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