I have two questions regarding loading tables which are defined as RCFile,
Sequencfile etc.
Q1.
1. Suppose a table is defined as STORED AS RCFILE or SEQUENCEFILE, how do
we load this table. If source data file is in CSV format, do we have to load
that file in some temp table and then lo
Hi
I have staged table as
hive (revise)> desc employees_se;
OK
namestring
salaryfloat
subordinates array
deductions map
adr struct
I am trying to insert the data in partitioned table employees as
hive (revise)> desc e
I have a very basic question regarding Hadoop & Hive setup. I have 7 Machines
say M1,M2,M3,M4,M5,M6,M7
Hadoop Cluster Setup:
Namenode: M1
Seondary Namenode: M2
Datanodes: M3,M4,M5
Now question is:
Where do I need to install Hive.
1. Should I install Hiverserver on M6
a. if yes
Hi
I was playing with external table in hive and it got me confused as concept of
external as explain in documentation and practical implementation is not going
correctly.
Hive Version : 0.7
CREATE EXTERNAL TABLE IF NOT EXISTS learn.crime_external_native (
Orig_State String,
TypeofCrime String
I come across. Let me know if I am wrong.
Thanks,
Kuldeep
From: Kuldeep Chitrakar [mailto:kuldeep.chitra...@synechron.com]
Sent: 30 July 2012 18:32
To: user@hive.apache.org; bejoy...@yahoo.com
Subject: RE: Data Loaded but Select returns nothing!
Hi Bejoy,
I modified the load command as below
have not spefied a partition in Load.
Regards
Bejoy KS
Sent from handheld, please excuse typos.
From: Kuldeep Chitrakar
mailto:kuldeep.chitra...@synechron.com>>
Date: Mon, 30 Jul 2012 06:58:33 -0500
To:
user@hive.apache.orgmailto:user@hive.apache.org%
? 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<mailto:user@hive.apache.org>
Objet : Data Loaded but Select returns nothing!
Hi
I am
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)
Hi
What does RESTRICT and CASCADE stands for in Hive drop database commands.
Syntax: DROP (DATABASE|SCHEMA) [IF EXISTS] database_name [RESTRICT|CASCADE];
I tried to use them but no effect.
Thanks,
Kuldeep
:24
To: user@hive.apache.org
Subject: Re: Dimensional Data Model on Hive
On Thu, May 10, 2012 at 9:26 AM, Kuldeep Chitrakar
wrote:
> Hi
>
>
>
> I have data warehouse implementation for Click Stream data analysis on
> RDBMS. Its a start schema (Dimensions and Facts).
>
>
>
Hi
I have data warehouse implementation for Click Stream data analysis on RDBMS.
Its a start schema (Dimensions and Facts).
Now if i want to move to Hive, Do i need to create same data model as
Dimensions and facts and join them.
I should create a big de-normalized table which contains all tex
13 matches
Mail list logo
