Skip to Content
avatar image
Former Member

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.


Add comment
10|10000 characters needed characters exceeded

  • Former Member

    the bi version is bi4.2 sp3 ,jdbc connection driver is hive1.0 hiveserver2 j.

    and i found it's ok if i use odbc.

  • Get RSS Feed

0 Answers