on 04-24-2019 10:29 AM
We have created a datasource table in Vora 2.1 using Vora tools. Please find the below scripts:
DROP TABLE TABLE001
CREATE TABLE TABLE001 (a1 double, a2 int, a3 varchar(*)) TYPE DATASOURCE STORE IN MEMORY
ALTER TABLE TABLE001 ADD DATASOURCE WEBHDFS('swebhdfs://hostname:port//user/vora/test.csv')
LOAD TABLE TABLE001
Question : we would like to extract all the datasource path which has been used for loading this table. In the above example we want to extract the path as "hostname:port//user/vora/test.csv". Is there any metadata tables or sys tables in Vora 2.1 which would provide us this information.
We tried the below statement in Vora and it does not work.
describe formatted <tablename>
Also we tried the following sys tables in Vora
sys.table_columns
sys.internal_tables
But it does not contain any information regarding location or path use for loading the datasoure tables.
Thanks.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.