forked from docs/doc-exports
Su, Xiaomeng
12dd64efc7
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com> Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
1.9 KiB
1.9 KiB
How Do I Specify an OBS Path When Creating an OBS Table?
Scenario
When creating an OBS table, you must specify a table path in the database. The path format is as follows: obs://xxx/database name/table name.
Correct Example
CREATE TABLE `di_seller_task_activity_30d` (`user_id` STRING COMMENT' user ID...) SORTED as parquet LOCATION 'obs://akc-bigdata/akdc.db/di_seller_task_activity_30d'
Incorrect Example
CREATE TABLE `di_seller_task_activity_30d` (`user_id` STRING COMMENT' user ID...) SORTED as parquet LOCATION 'obs://akc-bigdata/akdc.db'
If the specified path is akdc.db, data in this path will be cleared when the insert overwrite statement is executed.
Parent topic: Job Development