Re: Error Fetching results: java.io.EOFException

2015-08-11 Thread Prem Yadav
Please check hive logs and post a few lines before the stacktrace. I have seen this error sometimes due to permissions issue. On Tue, Aug 11, 2015 at 9:32 AM, Matthias Kricke wrote: > Hi, > > > > I’m using Hive 0.14.0.2.2.6.0-2800. When sending queries I get this stack > trace: > > 2015-08-11 07

Error Fetching results: java.io.EOFException

2015-08-11 Thread Matthias Kricke
Hi, I'm using Hive 0.14.0.2.2.6.0-2800. When sending queries I get this stack trace: 2015-08-11 07:39:00,844 WARN [HiveServer2-Handler-Pool: Thread-36]: thrift.ThriftCLIService (ThriftCLIService.java:FetchResults(596)) - Error fetching results: org.apache.hive.service.cli.HiveSQLException: java

Re: hive benchmark

2015-08-11 Thread Noam Hasson
Sure, Even a single node with can support it, it's all a question of processing time. On Tue, Aug 11, 2015 at 9:31 AM, siva kumar wrote: > Hi Folks, > I need to insert 1 billion records into hive and > here is my cluster details. > > 1. 6-node Hadoop cluster cluster. > 2.

Re: How to create new table like existing with an extra column in single query.

2015-08-11 Thread venkatesh b
Ok finally got the solution. "Create table if not exists newTable as select oldTable.*, "" as newColumn from oldTable" Regards Venkatesh On Tuesday, August 11, 2015, venkatesh b wrote: > Thanks Adam. > > As mentioned we have a need that in a single query it should be done, > since ours is an a