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 output to an HDFS or local dire
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.
When I run a quer
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 wrote:
modify to say > 'CustomerId'
On Wednesday, J
modify to say > 'CustomerId'
On Wednesday, June 3, 2015 9:44 PM, Renuka Be
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 into table. What shall i
.
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 wrote:
you can explicitly set the split size
On Wednesday, May 13, 2015 11:37 PM, Pradeep Gollakota
wrote:
Hi All,
I'm writing an MR job to read
you can explicitly set the split size
On Wednesday, May 13, 2015 11:37 PM, Pradeep Gollakota
wrote:
Hi All,
I'm writing an MR job to read data using HCatInputFormat... however, the job is
generating too many splits. I don't have this problem when running queries in
Hive since it c
Query is pretty simple
CREATE TABLE SRC(ID INT, NAME STRING);
Yes HADOOP_HOME is set
From: Nitin Pawar mailto:nitinpawar...@gmail.com>>
Date: Friday, August 16, 2013 12:49 PM
To: Ankit Bhatnagar mailto:ank...@yahoo-inc.com>>
Cc: "user@hive.apache.org<mailto:user@hive.apach
quot;
mailto: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
mailto:ank...@yahoo-inc.
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
Hi Jasper,
could you please share your MR program.
I am not able to grab this character
Ankit
Hi Jasper,
How did you find - 'þ'
My browser shows this - �
Ankit
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
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
Hi
Please check your hive-site.xml.
Looks like issue with the cluster or config.
Ankit
Hi All,
Whats the best way to add custom serde jar.
looks like add jar says added successfully and I am able to list that jar in
hive interface
However Create table fails to find the class.
Thanks
Ankit
Hi Larry,
add jar -- successful
However
create table my_table(a string, b string, c string)
> row format serde 'com.test.CSVSerde'
> stored as textfile;
when I execute the query-I get error
Error in metadata: Cannot validate serde: com.vantage.hive.CSVSerde
FAILED: Execution Error
Hi All,
Just wondering if someone can throw some light on the fact how are the
column names and types are provided to Deserializer while creating table.
@Override
public void initialize(Configuration conf, Properties tbl)
throws SerDeException {
}
I understand that above accept that i
Hi All,
I am planning to join some csv files using hive.
referring to the developer guide on wiki quotes are not supported.
---
Hive currently use these SerDe classes to serialize and deserialize data:
-
MetadataTypedColumnsetSerDe: Th
18 matches
Mail list logo
