Skip to content

Instantly share code, notes, and snippets.

@ianbeckett
ianbeckett / 1 - setup_query.hql
Last active December 27, 2015 02:39
Hive Java error when using a view with a sub-query from inside another sub-query and including non-views in the FROM clause
-- 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