Hi, I'm trying to integrate the ODBC connectivity to Hortonworks plateform into our marketing data management software I'm having an issue runing a query INSERT INTO TableX (Col1) SELECT col1 from Table1 UNION SELECT col2 FROM Table2 using the ODBC connection where as the exact same statement works fine when run through Hive View Here are some details : Structure of tables used as sources: CREATE TABLE wkf107422_10_1( sextkey STRING,
sinfosfirstname STRING,
sinfosname STRING,
spersid STRING);
ALTER TABLE wkf107422_10_1 SET SERDEPROPERTIES ('serialization.encoding'='UTF8') CREATE TABLE wkf107422_11_1( sextkey STRING,
sinfosfirstname STRING,
sinfosname STRING,
spersid STRING);
ALTER TABLE wkf107422_11_1 SET SERDEPROPERTIES ('serialization.encoding'='UTF8') ; Structure of the table used as destination CREATE TABLE wkf107422_12_1_0( sextkey STRING,
sinfosfirstname STRING,
sinfosname STRING,
spersid STRING) ;
ALTER TABLE wkf107422_12_1_0 SET SERDEPROPERTIES ('serialization.encoding'='UTF8') ; Statements that is failing : INSERT INTO wkf107422_12_1_0 ( spersid )
SELECT spersid FROM wkf107422_11_1 UNION SELECT spersid FROM wkf107422_10_1 Any advice on what I'm doing wrong there ? Best regards
... View more
