I believe Hive does not have any feature, which can provide this
information. You may like to write a custom Map / Reduce program and get
the file name being processed as shown below-
((FileSplit) context.getInputSplit()).getPath()
and then emit the file name when an occurrence of the word is fou
Hi Kuldeep
The syntax doesn't look fine to me, to load data manually into
partitions you need two statements for 2 partitions
LOAD DATA LOCAL INPATH '/home/cloudera/CrimeHive_Albana.csv' INTO
TABLE crime_managed_native PARTITION (State='Alabama');
LOAD DATA LOCAL INPATH '/home/cloudera/CrimeHive_C
I got it. I am running Hive 7.0 which requires each partition to be loaded
separately basically
PARTITION (State='Alabama',State='California'); wont work.
Need to change it to
PARTITION (State='Alabama');
PARTITION (State='California');
This is what I come across. Let me know if I am wrong.
T
An idea, in addition to what others have said... You are starting with a
complex table schema. Start simpler, test it as you go, and then work up to
partitions and buckets. That way you make sure you have the basic features
working correctly.
Chuck Connell
Nuance R&D Data Team
Burlington, MA
Hi Bejoy,
I modified the load command as below
LOAD DATA LOCAL INPATH '/home/cloudera/CrimeHive.csv' INTO TABLE
crime_managed_native PARTITION (State='Alabama',State='California');
Now data is loaded however when I issue command as
Select *from crime_managed_native where State='Alabama'
No re
Hi
I am using Hive CLI (Cloudera VM). Yes i am using Hive from /user/bin
Thanks,
Kuldeep
From: Matouk Iftissen [mailto:miftis...@cyres.fr]
Sent: 30 July 2012 17:44
To: user@hive.apache.org
Subject: RE: Data Loaded but Select returns nothing!
What do you use CLI (from command) or UI like HUE ?
Kuldeep
Couple of things I hoticed here are
Your table is bucketed, when you load data into a bucketed table you need to
enable
hive.enforce.bucketing=true;
Bucketing needs a MR job so you need to load the non bucketed data into a
normal table and from that load to a bucketed table using 'Ins
What do you use CLI (from command) or UI like HUE ? if you use CLI make sure
that you are in hive cmd (.../bin /hive>)
De : Kuldeep Chitrakar [mailto:kuldeep.chitra...@synechron.com]
Envoyé : lundi 30 juillet 2012 13:59
À : user@hive.apache.org
Objet : Data Loaded but Select returns nothing!
Hi
I am trying to load a CSV file into HIve table.
Everything works fine but when a fire "select * from tablename" command. It
does not retun anything.
--Create Table
CREATE TABLE IF NOT EXISTS learn.crime_managed_native (
NoState String,
TypeofCrime String,
Crime String,
Year int,
Count int)
Hello every one
Is there any driver ODBC developed by cloudera or others (rather then ODBC
developed for Tableau because it does not work on Windows Server 2008 R2 64bit)
to use it with cognos BI server (8.4) for OS (on Windows Server 2008 R2 64bit).
Thanks.
Best regards.
Matouk Iftissen
10 matches
Mail list logo
