Here's a query that works in Hive, but gives a syntax error in Kylin. Any
idea why?
select part_dt, kylin_sales.LEAF_CATEG_ID, LSTG_FORMAT_NAME, LSTG_SITE_ID,
META_CATEG_NAME, sum(price), max(price), min(price) from kylin_sales INNER
JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as KYLIN_CATEGORY_GROUPINGS ON
KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND
KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID group by
part_dt, kylin_sales.LEAF_CATEG_ID, LSTG_FORMAT_NAME, LSTG_SITE_ID,
META_CATEG_NAME order by part_dt, kylin_sales.LEAF_CATEG_ID,
LSTG_FORMAT_NAME, LSTG_SITE_ID, META_CATEG_NAME;
Error message:
Encountered "DEFAULT" at line 1, column 156. Was expecting one of:
<IDENTIFIER> ... <QUOTED_IDENTIFIER> ... <BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ... <UNICODE_QUOTED_IDENTIFIER> ... "LATERAL"
... "(" ... "UNNEST" ... "TABLE" ...