Re: Hive TxnHandler::lock method run into dead lock.

2017-03-23 Thread Eugene Koifman
Can you try use “hikaricp” connection pool manager? It seems to be using default which is no limit. Eugene From: Igor Kuzmenko Reply-To: "user@hive.apache.org" Date: Monday, March 20, 2017 at 2:17 PM To: "user@hive.apache.org" Subject: Re: Hive TxnHandler::lock method run into dead lock. S

RE: Regarding removing double quotes

2017-03-23 Thread Brotanek, Jan
Hello, you can use SerDe which has double quotes as default quoting char CREATE TABLE a1.test (a string, b string ) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' WITH SERDEPROPERTIES ( "separatorChar" = "," ) Regards Jan From: elango vaidyanathan [mailto:elango...@gmail.com] S

Re: Regarding removing double quotes

2017-03-23 Thread Suresh Kumar Sethuramaswamy
Hi Elango, Did you try openCSVserde? Regards Suresh On Thu, Mar 23, 2017 at 1:43 AM elango vaidyanathan wrote: > > Hi all, > > I am loading a CSV file into hive. All the columns in the CSV file has > values with in the double quotes. How do i remove them and load into hive? > > Thanks, > E