Skip to Content
Former Member
Nov 23, 2016 at 01:50 AM

idt with hadoop error


hi all

i got an error connecting to hadoop with 3 tables join .the error is :

infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: ParseException line 1:150 extraneous input '_SYNTHJOIN_b1d777c6___Table__1actual_total_fee_' expecting ) near '<EOF>'


i checked the sql was running ok in hadoop hive:

SELECT Table__1.`biz_order_id`, sum(Table__1.`actual_total_fee`), Table__5.`name`, max( Table__3.`id` ) FROM `yimay`.`yw_category` Table__5 JOIN `yimay`.`yw_tc_biz_order` Table__1 ON (Table__1.`category_id`=Table__5.`id`) JOIN `yimay`.`yw_item` Table__3 ON (Table__1.`item_id`=Table__3.`id`) GROUP BY Table__1.`biz_order_id`, Table__5.`name`, Table__3.`id`

but if i remove "sum" "max" and "group by" or join tow tables only, the sql running ok.

anyone could help me.