Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive-ODBC error in encoding

avatar

i am using hortonworks ODBC-Hive to connect from php page to hive , the problem is to search not English character especially Arabic character i made change in the hortonworks.hiveodbc.ini to value << DriverManagerEncoding=UTF-8> , what further edit i can do in configuration of odbc driver and when i query the result i have this value

\u001a\u001a\u001a\u001a\u001a\u001a\u001a\u001a\u001a\u001a\u001a
1 ACCEPTED SOLUTION

avatar

Yes, i read it , but it only mention the edit in hortonworks.hiveodbc.ini , and i made this edit but nothing changes

@Amine Hallam , please what else can i do to make it work ;

View solution in original post

3 REPLIES 3

avatar
Expert Contributor

Did you checked this document here ?

avatar

Yes, i read it , but it only mention the edit in hortonworks.hiveodbc.ini , and i made this edit but nothing changes

@Amine Hallam , please what else can i do to make it work ;

avatar

hi @Amine Hallam , thanks for your response but i solved after 4 days searching . the problem was in the configuration of the apache server . i change the configuration of etc/apache2/envar ,

comment << EXPORT LNAG = C >>

then

uncomment ./etc/default/local

i hope it help any