Skip to main content
Question

Export To S3 And External table

  • March 8, 2021
  • 2 replies
  • 12 views

JimmyAndreson

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 !VidMate

2 replies

Nimmi_gupta
Forum|alt.badge.img
  • Participating Frequently
  • March 8, 2021

@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


Sudhakar_B
Forum|alt.badge.img+1
  • Participating Frequently
  • March 15, 2021