I have an ETL engine that can create .parquet file . How can I create an external table against the parquet file ?
Is that allowed ?
You can use create statement as specified below:
CREATE EXTERNAL TABLE ORDERS (ORDER_ID INT, ORDER_DATE BIGINT,order_customer_id INT,order_status STRING)STORED AS PARQUETLOCATION '/user/mapr/parquet';
Make sure: Column names in hive should match with column names in parquet file
I am not sure if I understand your question. When you ask "can I create an external table against the parquet file" do you have any tool in particular in mind?. Perhaps if you can share more about the error or limitations you are facing in your use case I can understand better.
Retrieving data ...