Hi,
Any exceptions in the log file?
Try this for loading into partions. In your scenario if it is possible
with load query.
LOAD DATA INPATH '/user/myname/kv2.txt' OVERWRITE INTO TABLE invites
PARTITION (ds='2008-08-15');
Hope it helps,
Chinna
>
>
Hi,
Hive is mavenized, so please follow this link to build
https://cwiki.apache.org/confluence/display/Hive/HowToContribute#HowToContribute-MakingChanges
Hope It Helps you,
On Tue, Mar 25, 2014 at 9:12 PM, Nagarjuna Vissarapu <
nagarjuna.v...@gmail.com> wrote:
>
> Hi,
>
> Can you please
Hi,
In hive different types of joins are there like join, map join , bucket map
join and etc.
Please take a look of these it may help you to optimize your query
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+JoinOptimization
https://www.facebook.com/notes/facebook-engineering/j
Hi,
1. Start Hiveserver
2. In php client code set THRIFT_ROOT to php lib of hive distribution
(Ex: /home/install/apache-hive-0.14.0-SNAPSHOT-bin/lib/php)
Hope It Helps,
Chinna
On Fri, Mar 28, 2014 at 12:14 AM, Jeremy wrote:
> Or how do query hive from php?
>
> On 03/27/2014 12:25 PM, Jere
Hi,
Number of mappers will depend on some factors like,
1.The number of mappers is defined based on our data size (By default set
to one per HDFS block).
2.The number of mappers depends on amount of InputSplit generated by
InputFormat#getInputSplits method. In particular FileInputSplit splits
in
Hi,
Can you add what is the causedby excetion...or full exception.
On Tue, Apr 1, 2014 at 11:09 AM, Rishabh Bhardwaj wrote:
> Hi all,
> I created the database 'test1' and a table 'my1'
> Now with show tables in test1 , hive shell is showing my1
> but when I am trying to do,
> describe my1;
>
Hi,
You need to install hive completely because both are different
processes(Installing hive is very simple and it require few
configurations). Hive process to work, it required Hadoop processes. I
think same with the pig also(I did't try)...
Hope It Helps,
Chinna..
On Tue, Apr 1, 2014 at 3:3
Hi,
Here the MR job is failed, Check why the MR job is failed (From the job
logs) ..
Hope It Helps,
Chinna Rao Lalam
On Fri, Apr 18, 2014 at 9:53 PM, Vince George (vincgeor) wrote:
> We have just configured a new Hive JDBC client with an upgraded support
> for per user Ke
Hi,
Check may be hive-exec.jar is corrupted.
Hope It Helps,
Chinna Rao Lalam
On Sat, Apr 19, 2014 at 2:38 AM, Abhishek Girish wrote:
> Hello,
>
> I am hitting an error while executing a Hive job inside MapReduce:
>
> *Code snippet:*
>
> String select1 = "SELECT a
Congratulations to Prasanth and Vaibhav!
On Fri, Apr 25, 2014 at 8:23 AM, Shengjun Xin wrote:
> Congratulations ~~
>
>
> On Fri, Apr 25, 2014 at 10:33 AM, Carl Steinbach wrote:
>
>> + Prasanth's correct email address
>>
>>
>> On Thu, Apr 24, 2014 at 7:31 PM, Xuefu Zhang wrote:
>>
>>> Congratul
Hi,
In your code if more connections and statements are created?. If so,
closed those connections?
After use close unused connections and statements.
Hope It Helps,
Chinna
On Tue, Apr 29, 2014 at 3:47 PM, Dima Fadeyev wrote:
> Hello everyone,
>
> When I run a jdbc example from
> https://c
generates
independent tasks if this
property is true it will execute the independent tasks parallely otherwise it
will execute sequentially.
Thanks&Regards,
Chinna Rao Lalam
From: Ghousia [ghousia.ath...@gmail.com]
Sent: Tuesday, November 15, 2011 6:
Hi,
Pls check this property " javax.jdo.option.Multithreaded " it is introduced in
trunk in 0.8 version as part of HIVE-2022 . If the value is true it will make
JDO thread safe. Analyze this property can be added to 0.6 version or not if it
works.
Hope it helps,
Chinna
o the mail..
Hope it helps,
Chinna Rao Lalam
From: Ghousia [ghousia.ath...@gmail.com]
Sent: Monday, November 28, 2011 1:14 PM
To: user@hive.apache.org
Subject: ClassNotFoundException every time we run any hive query
Hi,
We always get this exception for any hiv
ion jline-0.9.94.jar will be used.
And send which version u r using..
Hope it helps,
Chinna Rao Lalam
From: ram prasad [rammca...@yahoo.co.in]
Sent: Monday, November 28, 2011 6:12 PM
To: Chinna Rao Lalam
Subject: Hive console startup issue
Hi ,
I m unab
p and hive) and any
modifications u have done for hadoop distribution...
Hope it helps,
Chinna Rao Lalam.
From: ram prasad [rammca...@yahoo.co.in]
Sent: Tuesday, November 29, 2011 4:40 PM
To: Chinna Rao Lalam
Subject: Hive startup issue
Hi Chinna,
Can u pls t
Hi,
org.apache.hadoop.hive.service.ThriftHive.getClusterStatus()
This API will return the cluster status pls check this API
Hope it helps,
Chinna Rao Lalam
From: Gabor Makrai [makrai.l...@gmail.com]
Sent: Friday, December 16, 2011 12:34 PM
To: user
caller_name,
cf_cdr:caller_number")
> TBLPROPERTIES("hbase.table.name" = "hb_cdr");
Hope It Helps,
Chinna Rao Lalam
From: Madhusudhana Rao Podila [madhusudhana_pod...@infosys.com]
Sent: Friday, January 27, 2012 3:01 PM
To: user@hive.apache.o
Hi,
Change the value of this property "hive.querylog.location" . By default value
is "/tmp/{user.name}"
Hope It Helps,
Chinna Rao Lalam
From: Black, Brent [brent.bl...@disney.com]
Sent: Friday, January 27, 2012 7:40 AM
To: 'user
Hi,
Try by giving permissions to that file.
From: Hezhiqiang (Ransom) [ransom.hezhiqi...@huawei.com]
Sent: Tuesday, June 05, 2012 8:56 AM
To: user@hive.apache.org
Cc: Zhaojun (Terry)
Subject: hive test faild ,Permission denied
Hi all.
When I run :
ant
Congratulations to all...
On Mon, Mar 23, 2015 at 11:38 PM, Carl Steinbach wrote:
> The Apache Hive PMC has voted to make Jimmy Xiang, Matt McCline, and
> Sergio Pena committers on the Apache Hive Project.
>
> Please join me in congratulating Jimmy, Matt, and Sergio.
>
> Thanks.
>
> - Carl
>
>
Congrats Mithun!
On Wed, Apr 15, 2015 at 11:34 AM, Mohammad Islam wrote:
> Congrats Mithun!
>
> --Mohammad
>
>
>
> On Tuesday, April 14, 2015 9:10 PM, Prasanth Jayachandran <
> pjayachand...@hortonworks.com> wrote:
>
>
> Congrats Mithun!
>
> Thanks
> Prasanth
>
>
>
>
> On Tue, Apr 14, 2015 a
By default beeline logs will come to console with log level WARN only. If
you need some changes update the beeline-log4j.properties.
On Wed, May 27, 2015 at 8:58 AM, r7raul1...@163.com
wrote:
>
> I use hive1.1.0 beeline remote connect to hiveserver2. When I submit query
> , only query result ret
To get table access info, need to enable
this "hive.stats.collect.tablekeys" property.. By default it is false..
Hope It Helps,
Chinna
On Tue, Jun 2, 2015 at 2:45 PM, Amitosh Anand, IDD M Tech, Computer Sci. &
Engg., IIT (BHU) Varanasi wrote:
> Hi,
>
> I have been trying to build a hook for hiv
In hive 'show views' is not supported..
Go through the below link it may give some pointers..
http://grokbase.com/t/hive/user/1275vp3bfc/how-to-list-all-views
On Tue, Jun 2, 2015 at 1:01 PM, Ravisankar Mani <
ravisankarm...@syncfusion.com> wrote:
> Hi Everyone,
>
>
>
>
Hi,
What version you are using and what is the environment..
On Thu, Jun 4, 2015 at 2:35 PM, Palani, MuthuKumar A <
muthu.ku...@firstdata.com> wrote:
> Hi Folks,
>
>
>
> We are experiencing an issue with Hive that we have not been able to
> solve for few weeks.
>
>
>
> Hiveserver2 stops loggin
Hi,
If you are table name is orc_table in the exception i can see the table
name as "test"
Moving data to: hdfs://:8020/apps/hive/warehouse/test
Failed with exception Unable to rename:
hdfs://:8020/tmp/hive/hdfs/d240f669-b238-4697-9315-5f77eefff887/hive_2015-05-20_21-44-22_028_879858558634852277
What is the error, can you add here..
On Thu, Jun 4, 2015 at 3:51 PM, Ankita Jhar
wrote:
> Hi,
> I attempted to configure the remote metastore I hive which did not
> succeed , so I reverted hive-site.XML settings to the previous ones ...now
> whenever I make any new changes to hive-site.XML I
Please check Hive Language Manual
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML
Hope It Helps,
Chinna
On Thu, Jun 4, 2015 at 4:28 PM, Sateesh Karuturi <
sateesh.karutu...@gmail.com> wrote:
> anyone help me please... how to write insert statement in hive 1.0.0?
>
--
Ho
Congratulations Zhihai...
On Fri, May 5, 2017 at 10:22 PM, Xuefu Zhang wrote:
> Hi all,
>
> I'm very please to announce that Hive PMC has recently voted to offer
> Zhihai a committership which he accepted. Please join me in congratulating
> on this recognition and thanking him for his contributi
Hi all.
Do we have any timelines for Hive 4.0.0 release.
Thanks,
Chinna
Hi All,
Is there any way to find Hive query to Datanucleus queries mapping.
"select * from table" this hive query will generate multiple Datanucleus
queries and execute on configured DB.
In our DB some of the queries are running slow, So we want to see
hivequery->datanucleus query mapping to find
op/hive/ql/metadata/Hive.java#L5405
>
> cheers,
> Zoltan
>
> On 2/10/20 1:07 PM, Chinna Rao Lalam wrote:
> > Hi All,
> >
> > Is there any way to find Hive query to Datanucleus queries mapping.
> >
> > "select * from table" this hive query will g
need to upgrade to protobuf-3.7.1.
HIVE-21939 <https://issues.apache.org/jira/browse/HIVE-21939> upgraded
protobuf-2.5.0 to protobuf-3.7.1, It have mainly 2 failures. We are working
on this.
Thanks,
Chinna Rao Lalam
two-step-work, first step we use
> one of the short-term plan to enable
> Hive on ARM, and 2nd Step, we look for the long run to discuss with HBase
> to find out a fesiable solution.
>
> BR,
>
> Zhenyu Zheng
>
> On Tue, Mar 10, 2020 at 9:29 PM Chinna Rao Lalam <
>
Hi Amit,
Pls check this issue HIVE-1405 it will help u .This issue targeting same
scenario.
Thanks
Chinna Rao Lalam
> Hi Chinna,
> That worked, Thanks a lot. So once the jar is picked up, is
> there a way
> to create a temporary function, that is retained even if i quit the
&
Hi Mark,
I think 'apache_logs' table created from hive shell and select command is
executed from 'hive -e'(outside) so the hive shell process is different and
'hive -e' process is different if derby started in embeded mode(hive by default
provided embeded derby) it can't see the tables of oth
org.apache.derby.jdbc.ClientDriver
Driver class name for a JDBC metastore
In hive/lib keep these derbyclient.jar,derbytools.jar jars
Start the derby in server mode in this machine {derbyIP}
Hope it helps,
Chinna Rao Lalam
- Original Message -
From: Matt Kennedy
Date: Monday, October 10, 2011 9:48 pm
Hi,
Check the org.apache.hadoop.hive.ql.exec.Operator and sub classes of the
operator java code
Hope it helps,
Chinna Rao Lalam
- Original Message -
From: "Yakubovich, Alexey"
Date: Thursday, October 13, 2011 2:38 am
Subject: comliler generated M-R tasks
To: "user@
Hi,
Can u post some more details like for the "list file" what command u have
used.
- Original Message -
From: Mohit Gupta
Date: Wednesday, October 19, 2011 3:16 pm
Subject: Re: Accessing distributed cache in transform scripts
To: user@hive.apache.org
> Plz help...Any pointers!!
>
Hi,
Check where u have configured some value to the "hive.metastore.uris"
property in hive-default.xml or hive-site.xml
and whether it is valid or not
Hope it helps
Chinna Rao Lalam
- Original Message -
From: kiranprasad
Date: Wednesday, October 19, 2011 3:08 pm
Subject
Hope it helps,
Chinna Rao Lalam
- Original Message -
From: Ankit Jain
Date: Wednesday, October 19, 2011 5:40 pm
Subject: Re: When trying to create table Iam getting exception
To: user@hive.apache.org
> Hi ,
>
> I can run query over hive through hive shell and using jdbc
> co
42 matches
Mail list logo
