Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unable to create materialized hive views with druid storage libs

Highlighted

Unable to create materialized hive views with druid storage libs

New Contributor

Hello all,

Can someone help me how to create Hive materialized views with druid storage lib. Below are the table schema configs I am using to create view.

 

CREATE table_view
STORED AS 'org.apache.hadoop.hive.druid.DruidStorageHandler'
AS
SELECT *
FROM table ;

 

ERROR:

Error: Error while compiling statement: FAILED: ParseException line 1:8 cannot recognize input near 'CREATE' 'table_view' 'STORED' in ddl statement (state=42000,code=40000)

Don't have an account?
Coming from Hortonworks? Activate your account here