Re: time travel using hive cli

co...@yahoo.com >> <mailto:second_co...@yahoo.com> wrote: >> >> Hive server is configured to read delta lake folder from cloud storage. I >> able to select * from tabletest using hive cli. But when I try >> >> describe history tabletest >> >>

Re: time travel using hive cli

elease supports this feature. Thanks, Peteer > On 2022. May 20., at 8:54, second_co...@yahoo.com wrote: > > Hive server is configured to read delta lake folder from cloud storage. I > able to select * from tabletest using hive cli. But when I try > > describe history tabletes

Hive CLI Error: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

Hi All, I'm new to Hive and did this tutorial: https://cwiki.apache.org/confluence/display/Hive/GettingStarted After the "Running Hive CLI" step I've decided to run the "show tables;" command and got this error: FAILED: HiveException java.lang.RuntimeEx

Alter Table by Hive Beeline doesn't reflect in Hive CLI and SparkSession

Hi all, I set up my HiveServer2(version 1.2.1) with remote metastore database(mysql) and embedded metastore server(hive.metastore.uris remains empty). Strange things happened when I do ALTER TABLE operations: 1. Open Beeline and Hive CLI in two window. Beeline connected to localhost(on which

Re: migrate hive cli to beeline

Should be reasonable for me. You should use hive for version as new as possible, Memory leak issue was included in hive's jira. For our production, hiveserver2 of 2.1.1 could run for log lifetime. 2017-11-22 15:04 GMT+08:00 游垂凯 : > Hello everyone: > Recently,I want to migra

Re: migrate hive cli to beeline

option, or it will hang and ultimately fail: "beeline --incremental=true" 2017-11-22 8:04 GMT+01:00 游垂凯 : > Hello everyone: > Recently,I want to migrate hive cli to beeline，but i'm reffered to > cloudera official site about hive beeline(https://www.cloudera. &g

migrate hive cli to beeline

Hello everyone: Recently,I want to migrate hive cli to beeline，but i'm reffered to cloudera official site about hive beeline(https://www.cloudera.com/documentation/enterprise/5-8-x/topics/cdh_ig_hive_install.html#concept_alp_4kl_3q), it describe that the beeline cli should use a

Re: Hive Cli ORC table read error with limit option

Thanks Prasanth for the update. I will test it and update it here the outcome. Thanks Biswa On Tue, Apr 19, 2016 at 6:26 AM, Prasanth Jayachandran < pjayachand...@hortonworks.com> wrote: > Hi Biswajit > > You might need patch from https://issues.apache.org/jira/browse/HIVE-11546 > > Can you appl

Re: Hive Cli ORC table read error with limit option

Hi Biswajit You might need patch from https://issues.apache.org/jira/browse/HIVE-11546 Can you apply this patch to your hive build and see if it solves the issue? (recommended) Alternatively, you can use “hive.exec.orc.split.strategy”=“BI” as workaround. Its highly not recommended to use this c

Re: Hive Cli ORC table read error with limit option

Hi All, I seriously need help on this aspect. Any reference or pointer to troubleshoot or fix this, could be helpful. Regards Biswa On Fri, Mar 25, 2016 at 11:24 PM, Biswajit Nayak wrote: > Prashanth, > > Apologies for the delay in response. > > Below is the orcfiledump of the empty orc file f

Re: Unable to start Hive CLI after install

What are you getting when trying $HIVE_HOME/bin/hive The error! Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpres

Re: Unable to start Hive CLI after install

Hi Mich -I did all those steps. Some how i am not able to find out whats the issue. Can you suggest any debugging tips ?Regards,Rajendra On Monday, April 4, 2016 12:16 PM, Mich Talebzadeh wrote: HI Raj, Hive 2 is as good to go :) Check this I see that you are using Oracle DB as your

Re: Unable to start Hive CLI after install

HI Raj, Hive 2 is as good to go :) Check this I see that you are using Oracle DB as your metastore. Mine is Oracle as well javax.jdo.option.ConnectionURL jdbc:oracle:thin:@rhes564:1521:mydb

Re: Unable to start Hive CLI after install

Thanks Mike. If Hive 2.0 is stable - i would definitely go for it. But let me troubleshoot 1.1.1 issues i am facing now. here is my hive-site.xml. Can you please let me know if i am missing anything. hive.exec.scratchdir /tmp/hive hive.metastore.local false hive.metastore.warehouse.dir h

Re: Unable to start Hive CLI after install

Sorry in a typo with your name - Mich. On Monday, April 4, 2016 12:01 PM, Raj Hadoop wrote: Thanks Mike. If Hive 2.0 is stable - i would definitely go for it. But let me troubleshoot 1.1.1 issues i am facing now. here is my hive-site.xml. Can you please let me know if i am missing anyt

Re: Unable to start Hive CLI after install

Interesting why you did not download Hive 2.0 which is out now The error says: HiveConf of name hive.metastore.local does not exist In you hive-site.xml how have you configured parameters for hive.metastore? HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAA

Unable to start Hive CLI after install

Hi, I have downloaded apache hive 1.1.1 and trying to setup hive environment in my hadoop cluster. On one of the nodes i installed hive and when i set all the variables and environment i am getting the following error.Please advise. [hadoop@z1 bin]$ hive 2016-04-04 10:12:45,686 WARN  [main] conf

Re: Hive Cli ORC table read error with limit option

Prashanth, Apologies for the delay in response. Below is the orcfiledump of the empty orc file from a broken partition. *$ hive --orcfiledump /hive/*testdb*.db/*table_orc */year=2016/month=1/day=29/00_0* *Structure for /hive/*testdb*.db/*table_orc */year=2016/month=1/day=29/00_0* *Fil

Re: Hive Cli ORC table read error with limit option

Alternatively you can send orcfiledump output for the empty orc file from broken partition. Thanks Prasanth On Mar 10, 2016, at 5:11 PM, Prasanth Jayachandran mailto:pjayachand...@hortonworks.com>> wrote: Could you attach the emtpy orc files from one of the broken partition somewhere? I can ru

Re: Hive Cli ORC table read error with limit option

Could you attach the emtpy orc files from one of the broken partition somewhere? I can run some tests on it to see why its happening. Thanks Prasanth On Mar 8, 2016, at 12:02 AM, Biswajit Nayak mailto:biswa...@altiscale.com>> wrote: Both the parameters are set to false by default. hive> set h

Re: impala like formatting of tables inside Hive cli

Try beeline tool to connect to HIve Server2. It may not be that aesthetically close. Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://t

impala like formatting of tables inside Hive cli

Is there a setting that will yield nicely formatted tables as in Impala. I am attaching an example of what I mean.

Re: Hive Cli ORC table read error with limit option

Both the parameters are set to false by default. *hive> set hive.optimize.index.filter;* *hive.optimize.index.filter=false* *hive> set hive.orc.splits.include.file.footer;* *hive.orc.splits.include.file.footer=false* *hive> * >>>I suspect this might be related to having 0 row files in the buc

Re: Hive Cli ORC table read error with limit option

> cvarchar(2) ... > Num Buckets: 7 I suspect this might be related to having 0 row files in the buckets not having any recorded schema. You can also experiment with hive.optimize.index.filter=false, to see if the zero row case is artificially produced via predi

Re: Hive Cli ORC table read error with limit option

Hi Gopal, I had already pasted the table format in this thread. Will repeat it again. *hive> desc formatted *testdb.table_orc*;* *OK* *# col_name data_typecomment * *row_id bigint * *a int

Re: Hive Cli ORC table read error with limit option

> Any one has any idea about this.. Really stuck with this. ... > hive> select h from testdb.table_orc where year = 2016 and month =1 and >day >29 limit 10; Depends on whether any of those columns are paritition columns or not & whether the table is marked transactional. > Caused by: java.lang.I

Re: Hive Cli ORC table read error with limit option

ql.io.orc.OrcInputFormat$SplitGenerator.call(OrcInputFormat.java:702)* > > * ... 4 more* > > *]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 > killedVertices:0* > > *hive> * > > > On Tue, Mar 1, 2016 at 1:09 PM, Biswajit Nayak > wrote: > >> Gopal, >> >> Any plan of provide the fix to Hive 1.x versions or to backport it? >> >> Regards >> Biswa >> >> On Tue, Mar 1, 2016 at 11:44 AM, Biswajit Nayak >> wrote: >> >>> Thanks Gopal for the details .. happy to know it has been counted and >>> fixed. >>> >>> Biswa >>> >>> >>> On Tue, Mar 1, 2016 at 11:37 AM, Gopal Vijayaraghavan >> > wrote: >>> >>>> >>>> > Yes it is kerberos cluster. >>>> ... >>>> > After disabling the optimization in hive cli, it works with limit >>>> >option. >>>> >>>> Alright, then it is fixed in - >>>> https://issues.apache.org/jira/browse/HIVE-13120 >>>> >>>> >>>> Cheers, >>>> Gopal >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>> >> >

Re: Hive Cli ORC table read error with limit option

t;> Biswa >> >> >> On Tue, Mar 1, 2016 at 11:37 AM, Gopal Vijayaraghavan >> wrote: >> >>> >>> > Yes it is kerberos cluster. >>> ... >>> > After disabling the optimization in hive cli, it works with limit >>> >option. >>> >>> Alright, then it is fixed in - >>> https://issues.apache.org/jira/browse/HIVE-13120 >>> >>> >>> Cheers, >>> Gopal >>> >>> >>> >>> >>> >>> >>> >> >

Re: Hive Cli ORC table read error with limit option

16 at 11:37 AM, Gopal Vijayaraghavan > wrote: > >> >> > Yes it is kerberos cluster. >> ... >> > After disabling the optimization in hive cli, it works with limit >> >option. >> >> Alright, then it is fixed in - >> https://issues.apache.org/jira/browse/HIVE-13120 >> >> >> Cheers, >> Gopal >> >> >> >> >> >> >> >

Re: Hive Cli ORC table read error with limit option

Thanks Gopal for the details .. happy to know it has been counted and fixed. Biswa On Tue, Mar 1, 2016 at 11:37 AM, Gopal Vijayaraghavan wrote: > > > Yes it is kerberos cluster. > ... > > After disabling the optimization in hive cli, it works with limit > >option.

Re: Hive Cli ORC table read error with limit option

> Yes it is kerberos cluster. ... > After disabling the optimization in hive cli, it works with limit >option. Alright, then it is fixed in - https://issues.apache.org/jira/browse/HIVE-13120 Cheers, Gopal

Re: Hive Cli ORC table read error with limit option

Thanks Gopal for the response. Yes it is kerberos cluster. After disabling the optimization in hive cli, it works with limit option. Below is the DESC details of the table that you asked for. *hive> desc formatted *testdb.table_orc*;* *OK* *# col_namedata_type comm

Re: Hive Cli ORC table read error with limit option

> Failed with exception java.io.IOException:java.lang.RuntimeException: >serious problem > Time taken: 0.32 seconds ... > Any one faced this issue. No, but that sounds like one of the codepaths I put in - is this a Kerberos secure cluster? Try disabling the optimization and see if it works. set

Hive Cli ORC table read error with limit option

Hi All, I am trying to run a simple query of select with limit option, it fails. Below are the details. Versions:- Hadoop :- 2.7.1 Hive :- 1.2.0 Sqoop :- 1.4.5 Query:- The table table_orc is partitioned based on year, month and day. And the table is ORC storage. hive> select date f

Re: How can we find Hive version from Hive CLI or Hive shell?

ing… > > Thanks & Regards, > Abhishek Dubey > > > From: Amrit Jangid [mailto:amrit.jan...@goibibo.com] > Sent: Wednesday, February 17, 2016 11:43 AM > To: user@hive.apache.org > Subject: Re: How can we find Hive version from Hive CLI or Hive shell? > > >&

RE: How can we find Hive version from Hive CLI or Hive shell?

S & REGARDS, > ABHISHEK DUBEY > > FROM: Amrit Jangid [mailto:amrit.jan...@goibibo.com] > SENT: Wednesday, February 17, 2016 11:43 AM > TO: user@hive.apache.org > SUBJECT: Re: How can we find Hive version from Hive CLI or Hive shell? > >>> hive --version > &

Re: How can we find Hive version from Hive CLI or Hive shell?

uot;user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: RE: How can we find Hive version from Hive CLI or Hive shell? Well thanks for the reply but it didn’t seems to work at my side. [cid:image003.png@01D1697A.2245C760] To be more precise, I

Re: How can we find Hive version from Hive CLI or Hive shell?

1:43 AM To: user@hive.apache.org<mailto:user@hive.apache.org> Subject: Re: How can we find Hive version from Hive CLI or Hive shell? >>hive --version Hive 0.13.1-cdh5.3.5 On Wed, Feb 17, 2016 at 11:33 AM, Abhishek Dubey mailto:abhishek.du...@xoriant.com>> wrote: Hi, How can we find

Re: How can we find Hive version from Hive CLI or Hive shell?

ike by querying or something… > > > > *Thanks & Regards,* > *Abhishek Dubey* > > > > > > *From:* Amrit Jangid [mailto:amrit.jan...@goibibo.com] > *Sent:* Wednesday, February 17, 2016 11:43 AM > *To:* user@hive.apache.org > *Subject:* Re: How can we find H

RE: How can we find Hive version from Hive CLI or Hive shell?

.com] Sent: Wednesday, February 17, 2016 11:43 AM To: user@hive.apache.org Subject: Re: How can we find Hive version from Hive CLI or Hive shell? >>hive --version Hive 0.13.1-cdh5.3.5 On Wed, Feb 17, 2016 at 11:33 AM, Abhishek Dubey mailto:abhishek.du...@xoriant.com>> wrote: Hi, How

Re: How can we find Hive version from Hive CLI or Hive shell?

>>hive --version Hive 0.13.1-cdh5.3.5 On Wed, Feb 17, 2016 at 11:33 AM, Abhishek Dubey wrote: > Hi, > > > > How can we find Hive version from Hive CLI or Hive shell? > > > > *Thanks & Regards,* > *Abhishek Dubey* > > > -- Regards, Amrit DataPlatform Team --

How can we find Hive version from Hive CLI or Hive shell?

Hi, How can we find Hive version from Hive CLI or Hive shell? Thanks & Regards, Abhishek Dubey

Re: HIVE CLI does not escape \t ?

>I use the workaround cat * >> output.tsv but that's not ideal. > >Any way to constrain the number of files to 1 automatically? I generally use an "ORDER BY 0" to insert a single reducer, which produces exactly 1 file. This is generally not a problem if you have say, <= 1 million rows. HDFS all

RE: HIVE CLI does not escape \t ?

ve.apache.org Cc : Thomas Achache Objet : Re: HIVE CLI does not escape \t ? > I¹m exporting a table with Hive CLI using hive ­f query.hql > file.tsv > Use ^A as a separator ... > Maybe using an alternative SerDe could solve that? Have you tried using the actual SerDe instead of t

Re: HIVE CLI does not escape \t ?

> I¹m exporting a table with Hive CLI using hive ­f query.hql > file.tsv > Use ^A as a separator ... > Maybe using an alternative SerDe could solve that? Have you tried using the actual SerDe instead of the stdout formatter? INSERT OVERWRITE LOCAL DIRECTORY '...'

HIVE CLI does not escape \t ?

Hi all, I’m exporting a table with Hive CLI using hive –f query.hql > file.tsv. The resulting tab separated file won’t read in R because it seems that some of my fields contain the \t separator and that Hive CLI is neither escaping those characters nor putting the chr fields within quo

RE: Hive CLI not starting

November 2015 18:07 To: user@hive.apache.org Subject: RE: Hive CLI not starting Yes it is Kerberized, how can I make sure ticket is not expired and TGT has not expired? Hive CLI works from edge node, We are trying to have another machine with Hive client thats where its failing. Any suggestion

RE: Hive CLI not starting

Yes it is Kerberized, how can I make sure ticket is not expired and TGT has not expired? Hive CLI works from edge node, We are trying to have another machine with Hive client thats where its failing. Any suggestion? From: Arpan Rajani [mailto:arpan.raj...@whishworks.com] Sent: 24 November

Re: Hive CLI not starting

t; Hi All, > > > > I’m trying to run Hive client from Linux box(Separate from Hadoop cluster > nodes) but when I start Hive CLI from command I get below error. > > Can somebody please suggest ? I’m not getting anything relevant on > internet. > > > > hive > >

Hive CLI not starting

Hi All, I'm trying to run Hive client from Linux box(Separate from Hadoop cluster nodes) but when I start Hive CLI from command I get below error. Can somebody please suggest ? I'm not getting anything relevant on internet. hive WARNING: Use "yarn jar" to launch YARN ap

Re: Hive CLI not working

With the given stacktrace I can say that your metastore db (derby) is read only or the user with whom you are trying to connect has read only permission only. Thanks Rajkumar Singh On Tue, Nov 3, 2015 at 2:54 PM, Vishwakarma, Chhaya < chhaya.vishwaka...@thinkbiganalytics.com> wrote: > > > Hi all

Hive CLI not working

Hi all, When I type "hive" command it hangs without going to hive prompt, when I checked logs I found below error. ERROR [BoneCP-pool-watch-thread]: bonecp.PoolWatchThread (PoolWatchThread.java:fillConnections(118)) - Error in trying to obtain a connection. Retrying in 7000ms java.sql.SQLExcept

does hive cli support concurrency?

Hi, I found a problem when I use hive. 1. In my environment, I have many threads, and every thread fork a process to run hive job using "hive -e sql"(not use hiveserver2, just use hive cli). Accidentally, one hive process couldn't close when the job is fininshed. I see the

Re: hive cli problem

he class path of HIVE. Another way is by running “export > HADOOP_USER_CLASSPATH_FIRST=true” instead of removing it. > > > > Yours, > > Ferdinand Xu > > > > From: Srinivas Thunga [mailto:srinivas.thu...@gmail.com] > Sent: Tuesday, March 10, 2015 1:51 PM > T

RE: hive cli problem

, March 10, 2015 1:51 PM To: user@hive.apache.org Subject: Re: hive cli problem 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

Re: hive cli problem

ues.apache.org/jira/browse/HIVE-8609?focusedCommentId=14215543&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14215543 > > Thanks > Prasanth > > On Mar 9, 2015, at 11:02 AM, Garry Chen wrote: > > Hi All, > New to hive

Re: hive cli problem

ment-tabpanel#comment-14215543 Thanks Prasanth On Mar 9, 2015, at 11:02 AM, Garry Chen mailto:g...@cornell.edu>> wrote: Hi All, New to hive and run into problem when try to lunch hive cli as follow. Please help. hadoop> hive Logging initialized using configuration in jar:

hive cli problem

Hi All, New to hive and run into problem when try to lunch hive cli as follow. Please help. hadoop> hive Logging initialized using configuration in jar:file:/u01/app/hive-1.1.0/lib/hive-common-1.1.0.jar!/hive-log4j.properties SLF4J: Class path contains multiple SLF4J bindi

Re: Hive CLI question

Bals's right, you can execute any shell command in hive-cli by using "!shell_command;" On Fri, Jan 2, 2015 at 4:30 AM, Bala Krishna Gangisetty wrote: > "!clear" is an another option too. > > --Bala G. > > On Thu, Jan 1, 2015 at 12:23 PM, Mohan Krishna

Re: Hive CLI question

"!clear" is an another option too. --Bala G. On Thu, Jan 1, 2015 at 12:23 PM, Mohan Krishna wrote: > Hi Louis > > I use "Ctrl+L" as a keyboard short cut to clear Hive screen. > > > > Thanks > Mohan > > On Fri, Jan 2, 2015 at 1:41 AM, Louis Vincent Frolio > wrote: > >> Does anyone know how to i

Re: Hive CLI question

Hi Louis I use "Ctrl+L" as a keyboard short cut to clear Hive screen. Thanks Mohan On Fri, Jan 2, 2015 at 1:41 AM, Louis Vincent Frolio wrote: > Does anyone know how to issue a clear screen at the "hive>" prompt? > Is this even possible? I am looking for something similar to "system > clear

Hive CLI question

Does anyone know how to issue a clear screen at the "hive>" prompt?Is this even possible?  I am looking for something similar to "system clear" in MySQL. Thank you, Louis.

Re: hive cli configuration quesiton

Glad to help.

Re: hive cli configuration quesiton

Thanks Douglas, This should solve my problem. Regards Jinyuan (Jack) Zhou On Mon, Jun 16, 2014 at 11:55 AM, Douglas Moore < douglas.mo...@thinkbiganalytics.com> wrote: > Hive CLI has a -i option. We create a pre.sql file with hive > settings and then specify: > hive -i pre.h

Re: hive cli configuration quesiton

Hive CLI has a -i option. We create a pre.sql file with hive settings and then specify: hive -i pre.hql -f query.hql On Mon, Jun 16, 2014 at 2:52 PM, Jinyuan Zhou wrote: > Hi, > I like to include common settings in one place when I run different hql > script via hive cli. > M

hive cli configuration quesiton

Hi, I like to include common settings in one place when I run different hql script via hive cli. My setting is really script specific, with my understanding of hive, hadoop, it is not very appropriate to put these settings in hive-site.xml, or hadoop configruation files. I don't want to r

Re: HiveServer2 with Hive CLI

You can try running derby in multi session mode. I did that , now I can use Hive web interface and hive CLI simultaneously On Wednesday, May 28, 2014, Amjad ALSHABANI wrote: > OOps, I forgot about that :) > > Thanks Dima to mention that. > > Actually where I m doing the test usin

Re: HiveServer2 with Hive CLI

he.org > *Subject:* HiveServer2 with Hive CLI > > > > Hello everybody, > > > > I m trying to start hiveserver2 to connect to hive via a PHP application, > but in the same time I would like to keep connecting Hive CLI ( hive> ) on > the same machine to execute s

RE: HiveServer2 with Hive CLI

You are using the default Derby metastore? There shouldn’t be any problem opening multiple connections to MySQL, Oracle or Postgres. From: Amjad ALSHABANI [mailto:ashshab...@gmail.com] Sent: Wednesday, May 28, 2014 11:42 AM To: user@hive.apache.org Subject: HiveServer2 with Hive CLI Hello

HiveServer2 with Hive CLI

Hello everybody, I m trying to start hiveserver2 to connect to hive via a PHP application, but in the same time I would like to keep connecting Hive CLI ( hive> ) on the same machine to execute some request manually. It seems that it is not possilbe to do so (the Hive thrift server seems

Re: exception when build Hive from source then start Hive CLI

ly move to maven from ant, but wiki still shows ant >> related command. >> >> Johnny >> >> >> On Wed, Nov 6, 2013 at 6:04 AM, 金杰 wrote: >> >>> Hi, Xiaoyu >>> >>> You may run hive cli using maven exec plugin >

Re: exception when build Hive from source then start Hive CLI

recently move to maven from ant, but wiki still shows ant > related command. > > Johnny > > > On Wed, Nov 6, 2013 at 6:04 AM, 金杰 wrote: > >> Hi, Xiaoyu >> >> You may run hive cli using maven exec plugin >> >> For example: >> >> j

Re: exception when build Hive from source then start Hive CLI

Hi, Jay, Thanks for your reply. Do you know the way to build a Hive tarball from source? Hive recently move to maven from ant, but wiki still shows ant related command. Johnny On Wed, Nov 6, 2013 at 6:04 AM, 金杰 wrote: > Hi, Xiaoyu > > You may run hive cli using maven exec plugi

Re: exception when build Hive from source then start Hive CLI

Hi, Xiaoyu You may run hive cli using maven exec plugin For example: jj@hellojinjie hive :) $ cd cli/ jj@hellojinjie cli :) $ mvn exec:java -Dexec.mainClass=org.apache.hadoop.hive.cli.CliDriver Best Regards 金杰 (Jay Jin) On Wed, Nov 6, 2013 at 11:11 AM, Zhang Xiaoyu wrote: > so looks l

Re: exception when build Hive from source then start Hive CLI

so looks like jline jar is maven dependency which is pulled to ~/.m2 folder. The question here is what is the right way to build a Hive tarball by maven command? looks like mvn clean install -DskipTests is not.. Thanks, Johnny On Tue, Nov 5, 2013 at 6:14 PM, Zhang Xiaoyu wrote: > Hi, all, >

exception when build Hive from source then start Hive CLI

Hi, all, I am trying to build hive from source and start CLI. What I did is (1) git clone the source (2) mvn clean install -DskipTests (3) cp */target/*.jar lib/ this step basically copy all jar files to lib (4) start cli by ./bin/hive I got exception ./bin/hive: line 80: [: /Users/admin/D

Re: Capturing HIVE CLI errors

The thrift libraries throw errors back to the client as one would expect. Looks like we're going to have to see some example code where you're not seeing them. On Tue, Oct 8, 2013 at 2:57 AM, praveenesh kumar wrote: > Hi guys, > > I am trying to write a client code fo

Capturing HIVE CLI errors

Hi guys, I am trying to write a client code for HIVE CLI via ODBC connector. I want to add query validation code at my client side. I was wondering is there a way I can capture the Hive query syntax errors which I can use to validate at my client end. I don't want to write my own valid

Re: Hive cli Vs beeline cli

Some notes from my experience * Beeline u have the benefit of being able to use LDAP/Kerberos authentication * I am not sure how to use -e and -f option with Beeline which is very strong with hive CLI * Beeline at the present version may not fully integrate with Oozie, so if u are

Hive cli Vs beeline cli

Hi pros, Based on your experience with beeline cli, could you please share your thoughts in advantages of using beeline cli over default hive cli? Please share if you find any useful link for this info. Thanks Pandeeswaran

Re: Numbers display in Hive CLI

Sure , let me explore hive beeline client  — Sent from Mailbox for iPad On Tue, Aug 13, 2013 at 11:24 PM, Stephen Sprague wrote: > Yeah. I would think i'd be a useful feature to have in the client - but > probably not the Hive CLI client. The Hive client seems pretty bare bones >

Re: Numbers display in Hive CLI

Yeah. I would think i'd be a useful feature to have in the client - but probably not the Hive CLI client. The Hive client seems pretty bare bones and my guess it'll probably stay that way. The Beeline client, however, looks to be where these kinds of bells and whistles probably could

Re: Numbers display in Hive CLI

Thanks Stephen! I shall check this . My requirement is controlling the formatting in session level using some properties set. Looks like, there's no such as of now . Would this be a good feature in hive cli? If many people think so, then I can file a feature request. — Sent from Mailbox for

Re: Numbers display in Hive CLI

well... a good 'ol search (let's not use the word google) of "hive udf" we find this: https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-StringFunctionsand there's a reference to a function called format_number(). or did you really want the *hive

Numbers display in Hive CLI

HI, I see the SUM(double_column) displays the result in scientific notation in the hive cli. Is there any way to customize the number display in hive CLI? -- Thanks, Pandeeswaran Hi, I am seeing the double values are displayed as scientifi not

Re: Hive CLI

Hi Rahul Is there a reason why u use Hive CLI ? I have aliases defined that I use, so I never had to use Hive CLI again alias hivescript='hive -e ' alias hivescriptd='hive -hiveconf hive.root.logger=INFO,console -e ' So when I want to run hive commands from Linux I j

Re: Hive CLI

Hi Rahul, The same shortcuts ctrl+A and ctrl+E works in hive shell for me( hive 0.9) Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- From: rahul kavale Date: Tue, 9 Jul 2013 11:00:49 To: Reply-To: user@hive.apache.org Subject: Hive CLI Hey there

Re: Hive CLI

Sorry My bad, it was my bad as Ctrl-a was screen binding which is why I was not able to use it for moving cursor. This had nothing to do with Hive or its configuration. My bad Thanks & Regards, Rahul On 9 July 2013 11:00, rahul kavale wrote: > Hey there, > I have been using HIVE(0.7) for a whi

Hive CLI

Hey there, I have been using HIVE(0.7) for a while now using CLI and bash scripts. But its a pain to move cursor in the CLI i.e. once you enter a very long query then you cant go to start of the query (like you do using Ctrl+A/Ctrl+E in terminal). Does anyone know how to do it? Thanks & Regards, R

Re: How to Disable Hive CLI interactive mode

e.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Re: How to Disable Hive CLI interactive mode ok. so there you go. IMO, you're going to have to create a custom wrapper around hive so that your users find your wrapper (via PATH) before they f

Re: How to Disable Hive CLI interactive mode

t; From: Stephen Sprague > Reply-To: "user@hive.apache.org" > Date: Wednesday, May 15, 2013 5:28 PM > To: "user@hive.apache.org" > Subject: Re: How to Disable Hive CLI interactive mode > > not sure i understand. you're asking how to disable "hive&qu

Re: How to Disable Hive CLI interactive mode

he.org>> Date: Wednesday, May 15, 2013 5:28 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Re: How to Disable Hive CLI interactive mode not sure i understand. you're asking how to disable "hive" (with

Re: How to Disable Hive CLI interactive mode

i've completely misunderstood the question could you elaborate? On Wed, May 15, 2013 at 2:32 PM, Sanjay Subramanian < sanjay.subraman...@wizecommerce.com> wrote: > Hi > I want to disable Hive CLI interactive mode for Hive clients in production > accessing Hive. Mainly

Re: hive cli escaping TAB and NEW LINE Characters.

** ** > > Regards > > Sathish Valluri > > ** ** > > *From:* Sanjay Subramanian [mailto:sanjay.subraman...@wizecommerce.com] > *Sent:* Saturday, May 04, 2013 12:08 AM > *To:* user@hive.apache.org > > *Subject:* Re: hive cli escaping TAB and NEW LINE Characters.***

RE: hive cli escaping TAB and NEW LINE Characters.

the data and display. Regards Sathish Valluri From: Sanjay Subramanian [mailto:sanjay.subraman...@wizecommerce.com] Sent: Saturday, May 04, 2013 12:08 AM To: user@hive.apache.org Subject: Re: hive cli escaping TAB and NEW LINE Characters. +1 to Stephens suggestion... From: Stephen

Re: hive cli escaping TAB and NEW LINE Characters.

e.org>" mailto:user@hive.apache.org>> Subject: Re: hive cli escaping TAB and NEW LINE Characters. hate to sound like a broken record but when all else fails think about the transform() function. The notion here is of encoding your tabs and newlines to something like '\t' and &

Re: hive cli escaping TAB and NEW LINE Characters.

t;<>' (you get the idea) then having your app decode those strings to real tabs and real newlines when reading it. What do you think? On Fri, May 3, 2013 at 2:07 AM, Valluri, Sathish wrote: > Hi All,**** > > ** ** > > We have an application which parses hive cli ou

hive cli escaping TAB and NEW LINE Characters.

Hi All, We have an application which parses hive cli output and displays results. I have an external table with data in avro format, the contents in this avro file have TAB and NEW LINES in the Avro data part. Since hive cli output rows are delimited by NEWLINES and columns are delimited by

Re: Set JobClient properties from hive CLI

Thanks Mike. From: Mike Liddell To: "user@hive.apache.org" ; sumit ghosh Sent: Monday, 22 April 2013 11:02 AM Subject: RE: Set JobClient properties from hive CLI Dropping u...@hadoop.apache.org   try “set hive.exec.counters.pull.interval = 5000;

RE: Set JobClient properties from hive CLI

2013 6:40 PM To: user@hive.apache.org; sumit ghosh; u...@hadoop.apache.org Subject: Re: Set JobClient properties from hive CLI Hi, Sending to a wider audience - How do I set jobclient.progress.monitor.poll.interval in Hive? Thanks, Sumit From: sumit ghosh mailto:sumi...@yahoo.com>> To:

  1   2   >