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 |