Skip to content

Instantly share code, notes, and snippets.

@ianbeckett
ianbeckett / 1 - setup_query.hql
Last active Dec 27, 2015
Hive Java error when using a view with a sub-query from inside another sub-query and including non-views in the FROM clause
View 1 - setup_query.hql
-- Create a simple table with 2 columns
-- and then create view that uses the table
-- and has a sub query
CREATE EXTERNAL TABLE IF NOT EXISTS TestTable (
TestID INT,
TestText STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE