Skip to Content
0

idt with hadoop error

Nov 23, 2016 at 01:50 AM

23

avatar image

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.

tks.

10 |10000 characters needed characters left characters exceeded

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.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers