question Re: Hive-ODBC error in encoding in Archives of Support Questions (Read Only)

Hive-ODBC error in encoding

mohamedhssm89 — Thu, 07 Dec 2017 23:49:07 GMT

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

Re: Hive-ODBC error in encoding

ahallam — Fri, 08 Dec 2017 02:17:09 GMT

Did you checked this document here ?

Re: Hive-ODBC error in encoding

mohamedhssm89 — Sat, 09 Dec 2017 03:20:26 GMT

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 ;

Re: Hive-ODBC error in encoding

mohamedhssm89 — Sun, 10 Dec 2017 04:42:53 GMT

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