Hive query exception


#1

can any body point out what’s wrong with this query,
create external table product1 as select * from product_replica where product_price>100
stored as parquet
location ‘/user/hariharanp1094/problem3/product/output’;

getting exception as
FAILED: ParseException line 2:0 missing EOF at ‘stored’ near '100’


#2

@Hariharan_Palanicham try the below create statement for product1 table creation.

create  table product1
stored as parquet
location '/user/hariharanp1094/problem3/product/output'
as select * from products where "product_price>100"