Re: Writing hive column headers in 'Insert overwrite query'

r u looking for  hive -e "set hive.cli.print.header=true; < query> " > output  On Tuesday, January 12, 2016 10:14 PM, Sreenath wrote: Hi All, Is there a way we can write the hive column headers also along with the output when we are overwriting a query's

Re: How to increase the mapper number in my case

check these> mapred.max.split.size > mapred.min.split.size On Friday, January 8, 2016 6:41 PM, Todd wrote: Hi, I have Hadoop (2.6.0, pseudo distributed mode) and Hive (1.2.1) installed on my local machine. I have a table A,its underlying file takes up 8 HDFS blocks.

Re: Query in HQL

modify to say 'CustomerId' On Wednesday, June 3, 2015 9:44 PM, Renuka Be renunalin...@gmail.com wrote: Hi Folks, Here is my query, select customerid as CustomerId  from Customers It returns table with column name as 'customerid', ' CustomerId' in the query was not reflected

Re: Query in HQL

cannot recognize input near 'as' ''CustomerId'' 'from' in selection target Query: select customerid as 'CustomerId' from Customers Regards,Renuka On Thu, Jun 4, 2015 at 12:49 AM, Ankit Bhatnagar ank...@yahoo-inc.com wrote: modify to say 'CustomerId' On Wednesday, June 3, 2015 9:44 PM

Re: HCatInputFormat combine splits

. mapreduce.input.fileinputformat.split.maxsize = 67108864 I'm still getting 1 Mapper per file. On Thu, May 14, 2015 at 10:27 AM, Ankit Bhatnagar ank...@yahoo-inc.com wrote: you can explicitly set the split size On Wednesday, May 13, 2015 11:37 PM, Pradeep Gollakota pradeep...@gmail.com

FAILED: Error in metadata: MetaException

Hi folks, FAILED: Error in metadata: MetaException(message:file:/user/hive/warehouse/src is not a directory or unable to create one) drwxrwxrwx - hadoop supergroup 0 2013-08-16 18:31 /user/hive/warehouse/src Is it some permission issue? Ankit

Re: FAILED: Error in metadata: MetaException

@hive.apache.orgmailto:user@hive.apache.org Subject: Re: FAILED: Error in metadata: MetaException Can you tell us what were you trying to do? create table? or executing a query on a table someone already created ? On Sat, Aug 17, 2013 at 12:32 AM, Ankit Bhatnagar ank...@yahoo-inc.commailto:ank

Re: FAILED: Error in metadata: MetaException

Query is pretty simple CREATE TABLE SRC(ID INT, NAME STRING); Yes HADOOP_HOME is set From: Nitin Pawar nitinpawar...@gmail.commailto:nitinpawar...@gmail.com Date: Friday, August 16, 2013 12:49 PM To: Ankit Bhatnagar ank...@yahoo-inc.commailto:ank...@yahoo-inc.com Cc: user

Re: Custom Serde with thorn

Hi Jasper, How did you find - 'þ' My browser shows this - � Ankit

Re: Custom Serde with thorn

Hi Jasper, could you please share your MR program. I am not able to grab this character Ankit

Re: Exception while running hive queries

Hi Please check your hive-site.xml. Looks like issue with the cluster or config. Ankit

Custom Serde with thorn

Hi I am facing a weird issue with the file parsing. My log files have a thorn 'þ' as separator. I tried writing a test case for deserializer and kind of confused by the fact it works fine as I pass the line to the deserializer, however when i run it on hive the line is not split into columns and

Fwd: Custom Serde with thorn

Hi I am facing a weird issue with the file parsing. My log files have a thorn 'þ' as separator. I tried writing a test case for deserializer and kind of confused by the fact it works fine as I pass the line to the deserializer, however when i run it on hive the line is not split into columns and