Export To S3 And External table
JimmyAndreson
Community Edition User
I export data to s3 with portion :
SELECT s3EXPORT_PARTITION(* USING PARAMETERS url='s3://bucket_name/test1/bystate.date') OVER (PARTITION BY name,date) FROM (SELECT name,TO_CHAR(ts, 'YYYYMMDD') AS date, * FROM T ) foo;
Now I want to create the external table with partition (date & name) base on the data in s3 I export before.
I can do that?
what kind of file the export create?it looks like CSV with '|' delimiter,
in this case, file CSV can be a part of the external table with a partition on name and date?
Thank you all !
0
Answers
@JimmyAndreson have you checked the below link. In the below forum link Jim_Knicely has explained about the s3EXPORT_PARTITION and how to create EXTERNAL TABLE with partition.
https://forum.vertica.com/discussion/242007/s3export-partition
@JimmyAndreson,
Exact same discussion here...
https://forum.vertica.com/discussion/comment/246107#Comment_246107
Hope this helps.