_SvIncludePlusContent-_DP_ImportConfig_Hadoop_Confluence 1
CREATE EXTERNAL TABLE IF NOT EXISTS some_db.datapipeline_export (
`page_id` string,
`instance_url` string,
`space_key` string,
`page_url` string,
`page_type` string,
`page_title` string,
`page_status` string,
`page_content` string,
`page_parent_id` string,
`labels` string,
`page_version` string,
`creator_id` string,
`last_modifier_id` string,
`created_date` string,
`updated_date` string,
`last_update_description` string
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
"escapeChar" = "\\",
'quoteChar' = '"',
'separatorChar' = ','
) LOCATION 's3://my-data-pipeline-bucket/test-exports/'
TBLPROPERTIES ('has_encrypted_data'='false');
Last modified on Mar 25, 2026
Powered by Confluence and Scroll Viewport.