Wednesday, March 15, 2017

Hue SQL tricks

I had to do the following to get a create table to run. Be aware that it will complain about everything without much of a clue as to the error.

1) I had to be in the area the source tables were in

2) Removed hive from all table references
 create table hive.ltobias.xyz

3) Removed the formatting from the to_date:
> to_date('2017-01-01', 'yyyy-MM-dd')
> to_date('2017-01-01')

4) Put backticks around items as alias (apparently, it's a keyword)
 join db1.items  `items` 


5) Remember to hit refresh to see the table. 

No comments:

Post a Comment