How to set the username when I execute hive commands?

2017-01-17 Thread Lee S
If the conf hive.server2.enable.doAs is false, default to user hive to execute all the hive sqls. Now I set this conf to true, and I want to set the username to make access to a directory. How can I do that?

Re: How to set hive.aux.jars.path in hive1.1.0?

2015-12-29 Thread Lee S
eyman Mohajerian : > >> Maybe you need to also add: >> >> HIVE_AUX_JARS_PATH = /path/to/JAR >> >> e.g.: >> http://www.cloudera.com/content/www/en-us/documentation/archive/manager/4-x/4-8-0/Cloudera-Manager-Managing-Clusters/cmmc_hive_udf.html >> &

Re: How to set hive.aux.jars.path in hive1.1.0?

2015-12-29 Thread Lee S
loudera.com/content/www/en-us/documentation/archive/manager/4-x/4-8-0/Cloudera-Manager-Managing-Clusters/cmmc_hive_udf.html > > > On Mon, Dec 28, 2015 at 11:52 PM, Lee S wrote: > >> Sorry, the is , forgive my wrong typing. Anybody can >> help? >> >> >

Re: How to set hive.aux.jars.path in hive1.1.0?

2015-12-28 Thread Lee S
Sorry, the is , forgive my wrong typing. Anybody can help? On Tue, Dec 29, 2015 at 3:50 PM, Lee S wrote: > Hi all: >I have a serde jar written by myself to deserialize some kind of data. > >I put the jar in the host of hiverserver and set the > *hive.aux.jars.path* p

How to set hive.aux.jars.path in hive1.1.0?

2015-12-28 Thread Lee S
Hi all: I have a serde jar written by myself to deserialize some kind of data. I put the jar in the host of hiverserver and set the *hive.aux.jars.path* property in hive-site.xml. Then I use beeline connecting to hiveserver2, create a table with the serde class, but it said class not

Re: How to set add jar jarpath within hive jdbc query?

2015-11-06 Thread Lee S
uster nodes. You >> dont need to add it part of your query >> >> On Thu, Nov 5, 2015 at 3:59 AM, Lee S wrote: >> >>> Hi all: >>> I try to execute hive query in a remote client through hive server2 >>> jdbc. >>> >>> I want to

How to set add jar jarpath within hive jdbc query?

2015-11-05 Thread Lee S
Hi all: I try to execute hive query in a remote client through hive server2 jdbc. I want to 'add jar' used as serde before create a table. But when I set the jar path local to the hive server host, it said the jar does not exist. And when I set the jar in the client , it said failed to rea

[help] create HiveMetaStoreClient on windows with problem

2015-06-11 Thread Lee S
Hi all, I installed hive with hcatlog on a linux cluster. And I tried to create HiveMetaStoreClient on windows,but it failes with exception below. Exception in thread "main" java.lang.NullPointerException at java.lang.ProcessBuilder.start(ProcessBuilder.java:1010) at org.apache.hadoop.util.Shell