I have created my first hql code, see below and I can't get any data to appear.. I have recently installed Sandbox. The installation comes with a few sample databases. I'm using the database called sample_07 to guide me with my own .hql code.
My hql code is as follows:
CREATE EXTERNAL TABLE mysample
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
TBLPROPERTIES ("skip.header.line.count" = "1");
However, when I run the code using Zeppellin Notebook with the following code, I can see the tables, but no data appears
select * from mysample limit 14
However, when I run the same code, with using the sample database called sample_07 both the tables and data appear.
I'm sure there is something very simple that I'm missing.
Can someone please let me know where I'm going wrong?