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
3) Removed the formatting from the to_date:
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.