Hi Team,
I am trying to write my query results to a file.
hive -e "alter table {0}.{1}
partition(year='{2}',month='{3}',day='{4}',hour='{5}') CONCATENATE >
/tmp/srinivas/test.log;"'.format(row[0],row[1],row[2],row[3],row[4],row[5])
Hi,
Use some query optimization techniques for query fast execution.
Use, Partitions, Bucketing or create table in ORC format
Regards,
Srinivas T
*Thanks & Regards,*
*Srinivas T*
On Tue, Dec 1, 2015 at 1:46 PM, San Luo wrote:
> Hi guys,
>
> My query runs slowly in hive, is there a tuning g
Can you please check metastore log?
*Thanks & Regards,*
*Srinivas T*
On Tue, Nov 3, 2015 at 4:40 PM, Rajkumar Singh
wrote:
> it seems that you are having a problem metastore.
>
> On Tue, Nov 3, 2015 at 1:46 PM, Mich Talebzadeh
> wrote:
>
>> Hi,
>>
>>
>>
>> Has anyone got a quick fix for dropp
Hi,
If you want those properties to executed, then you need to create table in
ORC format and need to change some configuration on Hive-Site.xml
Regards,
Srinivas T
*Thanks & Regards,*
*Srinivas T*
On Tue, Oct 27, 2015 at 12:05 PM, Lefty Leverenz
wrote:
> Oh, right -- I forgot that the tabl
Hi,
Have you created the hive metastore.
Have you changed the hive-site.xml with new config parameters ?
On Wednesday, September 9, 2015, Sateesh Karuturi <
sateesh.karutu...@gmail.com
> wrote:
> hello...,
> iam using hive 1.1 and tez 0.7...
> Whenever iam trying to INSERT data into hive table
Sudo service hiveserver2 stop
On Wednesday, April 29, 2015, CHEBARO Abdallah
wrote:
> Hello,
>
>
>
> How can I stop hiveserver2? I am not able to find the command.
>
>
>
> Thanks
>
> ***
>
> This e-mail contains information for the intended recipient only. It may
>
hi Mich,
Have you created the hive metastore? And can you please check the log for
hivemetastore
As i also faced this issue before.
And let me know
*Thanks & Regards,*
*Srinivas T*
On Tue, Apr 7, 2015 at 9:13 AM, Eugene Koifman
wrote:
> can you check that the schema in your metastore db ha
i am thinking to run hive-schema-0.14.0.mysql.sql. it will have 54 tables.
*Thanks & Regards,*
*Srinivas T*
On Tue, Mar 10, 2015 at 12:55 PM, Amith sha wrote:
> so can u suggest the solution
> Thanks & Regards
> Amithsha
>
>
> On Tue, Mar 10, 2015 at 12:53 PM, Sriniv
Hi,
I guess you have the sql as
hive-schema-1.1.0.mysql.sql
for this you will get only 45 tables only as Nucleus will not be there.
I am also faced the same problem
*Thanks & Regards,*
*Srinivas T*
On Tue, Mar 10, 2015 at 12:46 PM, Amith sha wrote:
> Now i am able to create a metastore dat
Hi,
I am also getting the same problem in Hive 1.1.0
As said by you, jline jar is not there in Hadoop.
How to find where this jar located and will be removed.
Mine is
Inside hadoop i am having folders like
client, client-0.20 and cloudera, lib
*Thanks & Regards,*
*Srinivas T*
On Mon, Mar 9
Hi,
After seeing your mail, i came to know that you are trying to update and
delete operations on Hive 1.0.
For doing the same,
After extracting Hive version, you have to create Hive meta store
http://www.cloudera.com/content/cloudera/en/documentation/cdh5/v5-1-x/CDH5-Installation-Guide/cdh5ig_
Hi,
Have you created the Hive Metastore?
http://www.cloudera.com/content/cloudera/en/documentation/cdh5/v5-1-x/CDH5-Installation-Guide/cdh5ig_hive_metastore_configure.html
and then try to start the server
*Thanks & Regards,*
*Srinivas T*
On Thu, Mar 5, 2015 at 2:57 PM, Pratik Gadiya
wrote:
Hi,
Then is there any way to achieve this?
*Thanks & Regards,*
*Srinivas T*
On Fri, Feb 27, 2015 at 9:53 AM, Siddharth Tiwari wrote:
> Not yet !
>
> Sent from my iPhone
>
> On Feb 26, 2015, at 8:23 PM, Srinivas Thunga
> wrote:
>
> Hi,
>
> Thanks for the pr
s not supported in 0.14. You have to insert into all the columns in
> the table and they have to match the order of items in the select or values
> clause.
>
> This will be supported in 1.2.
>
> Alan.
>
> Srinivas Thunga
> February 26, 2015 at 4:34
> Hi,
>
>
Hi,
I am using Hive 0.14
Can any one help me on to execute the below type query
insert into table emp (eid,ename) select * from dept where emp.id = dept.id
*Thanks & Regards,*
*Srinivas T*
Is your problem solved?
*Thanks & Regards,*
*Srinivas T*
On Wed, Feb 25, 2015 at 4:17 PM, Srinivas Thunga
wrote:
> Hi,
>
> You can set fetch size based certain datatype like blob, image, etc
>
> statement.setFetchSize(1000);
>
> Try this.
>
>
> *Thanks &
wing error for large data set
>
> Thanks
> Shweta Jadhav
>
>
>
> -Srinivas Thunga wrote: -
> To: "user@hive.apache.org"
> From: Srinivas Thunga
> Date: 02/25/2015 03:45PM
>
> Subject: Re: ERROR OutOfMemoryError: Java heap space
>
> not req
ERROR OutOfMemoryError: Java heap space
>
> I am running the query using spring batch framework.
>
> Thanks
> Shweta Jadhav
>
> -Srinivas Thunga wrote: -
> To: "user@hive.apache.org"
> From: Srinivas Thunga
> Date: 02/25/2015 02:43PM
> Subject:
red metastore as postgres db.
> Query is working fine in beeline command line interface but giving Heap
> space error while executing using JDBC java client.
>
> Thanks
> Shweta Jadhav
>
> -Srinivas Thunga wrote: -
> To: "user@hive.apache.org"
> From: Srin
select * from table;
>
> thanks
> Shweta Jadhav
>
>
>
> -Srinivas Thunga wrote: -
> To: "user@hive.apache.org"
> From: Srinivas Thunga
> Date: 02/25/2015 01:09PM
> Subject: Re:
>
> Hi,
>
> Can you place the query as well which you a
Hi,
Can you place the query as well which you are trying?
*Thanks & Regards,*
*Srinivas T*
On Wed, Feb 25, 2015 at 1:02 PM, Jadhav Shweta
wrote:
> Hi
>
> I am trying to run hive query
> Its getting executed from beeline interface
> but its throwing
>
>java.lang.OutOfMemoryError: Java h
TxnManager
> hive.compactor.initiator.on – true
> hive.compactor.worker.threads – 1
>
> *Thanks & Regards,*
>
> *Srinivas T*
>
> On Mon, Feb 23, 2015 at 9:31 PM, Jessica Zhang
> wrote:
>
>> Thanks for the reply! Would you please elaborate which new prope
hive.compactor.worker.threads – 1
*Thanks & Regards,*
*Srinivas T*
On Mon, Feb 23, 2015 at 9:31 PM, Jessica Zhang wrote:
> Thanks for the reply! Would you please elaborate which new properties for
> hive 0.14?
>
> Jessica
>
> On Feb 23, 2015, at 1:03 AM, Srinivas Thunga
> wrote:
>
> App
Apply new configuration properties for hive0.14 in hive-site.xml file then
drop or delete table
On Monday, February 23, 2015, Jie Zhang wrote:
> Hi,
>
> I have an application using hive, and just upgraded from 0.13.1 to 0.14.0.
> However, a bunch of unit testcases, which are using embedded derby
Refereed from the below link
https://cwiki.apache.org/confluence/display/Hive/HiveDeveloperFAQ#HiveDeveloperFAQ-HowdoIimportintoEclipse
?
Generating tarball resulted in below error.
#mvn clean package -DskipTests -Phadoop-1 -Pdist
ERROR::
Failed to execute goal on project hive-shims-common: C
25 matches
Mail list logo
