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 ... View more

i have this form of file as input ******************************************************************************************************* 2017-11-22 16:57:01.770651 IP 192.168.1.5.443 > 10.0.0.11.46250: Flags [P.], seq 1:47, ack 46, win 180, options [nop,nop,TS val 3232053199 ecr 2738373364], length 46 ************************************************************************************************************************************ i want to select only date,time,source,destination and then write them back in csv file . i use this script reader = csv.reader(open(inputStream,"rb"),delimiter=' ') for row in reader: outputStream.write(str([row[0],row[1],row[3],row[5]])) outputStream.write(str('\n')) put the output is like ['2017-11-18', '02:09:40.860818', '192.222.1.179.30106', '62.240.110.198.53:'] i want to remove the brackets and th qoutes ... View more