1. Got an error while running this query Message: Hive Inner Join Error: Unknown column '_20181101135949_subquery_13_1.mcp_id' in 'field list' Hive connections do not support 'INNER JOIN' syntax. Use [LEFT|RIGHT|FULL] [OUTER|SEMI] JOIN syntax.
2. Taking out the one line with mcp_id in the script from 1 after which I got the output without any error
3. The point to be noted is that the original script from 1 ran without any error in Ambari so I think Toad Data Point 4.3 somehow didn't like the line 'CURRENT_DATE AS mcp_id but I don't know why it showed inner join syntax error.
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center