Ranjith-AR edited a comment on pull request #4401: URL: https://github.com/apache/iceberg/pull/4401#issuecomment-1081379394
> > ```sql > CREATE EXTERNAL TABLE mytable ([(col_name1 col_datatype1, ...)]) > [PARTITIONED BY (col_name2 col_datatype2, ...)] > ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' > STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' > OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' > LOCATION '<symlink-table-root-path>' > ``` > > > The procedure looks like: > > ``` > CALL catalog.system.generate_symlink_format_manifest( > table => 'table_name', > symlink_root_location => 's3://some/path' > ); > ``` > > The `symlink_root_location` is optional. The default is `<table_root>/_symlink_format_manifest/<snapshot_id>`. A snapshot ID suffix is added because if this procedure is executed twice against the same table, we don't want to mix the results if the table is updated. If users want to use a consistent root path for the symlink table, it could be input as an override. > **in the above default location "<table_root>/_symlink_format_manifest/<snapshot_id>", what is the name of the manifest file ? <snapshot_id>_manifest ? does this mean that whenever I regenerate the symlink_format_manifest file, i have to alter the external table location to reflect the latest manifest file ? how to execute the procedure to override / exclude the snapshot_id prefix and generate manifest file like below "<table_root>/_symlink_format_manifest/manifest" ?** -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
