site.xml via CM.Also for location it should
be s3a:// not s3://
On Wed, Nov 7, 2018, 2:58 PM Garry Chen
mailto:g...@cornell.edu> wrote:
Hi Suresh,
I am using Hive 1.1.0-cdh5.14.4 and hive server log as below.
2018-11-07 19:43:16,581 WARN [main]: server.HiveServer2
(HiveServer2.java:startHi
your hive megastore logs?
On Wed, Nov 7, 2018, 2:19 PM Garry Chen
mailto:g...@cornell.edu> wrote:
hi All,
I am try to create a external table using s3 as location but
failed. I add my access key and security key in hive-site.xml and reboot the
server. Any suggestion?
hive&
hi All,
I am try to create a external table using s3 as location but
failed. I add my access key and security key in hive-site.xml and reboot the
server. Any suggestion?
hive> create external table kv (key int, values string) location
's3://cu-iclick/test';
FAILED: Execution
qualified columns fir common columns in bith tables...something
like this one
select date_key,ref, '' from master_request_tab a left join dm_search_eng b on
substr(ref, 1,length(a.engine)) = b.engine where a.engineis null;
On Oct 6, 2015 9:19 AM, "Garry Chen"
mailto:g.
Hi All,
Do you guys see any error in the following left join sql
statement? However, the hive give me error as "Error: Error while compiling
statement: FAILED: SemanticException [Error 10017]: Line 1:75 Both left and
right aliases encountered in JOIN 'engine' (state=42000,code=
with yarn, spark, mesos, or local please set the
spark.master to either local[*] or yarn-cluster
On Fri, Sep 25, 2015 at 10:45 PM, Xuefu Zhang
mailto:xzh...@cloudera.com>> wrote:
What's the value of spark.master in your case? The error specifically says
something wrong with it.
--Xuefu
On Fri,
Hi All,
I am following
https://cwiki.apache.org/confluence/display/Hive/Hive+on+Spark%3A+Getting+Started?
To setup hive on spark. After setup/configuration everything startup I am
able to show tables but when executing sql statement within beeline I got
error. Please help and
Hi All,
I am trying to configure hive 1.2.1 to support concurrency. In
order to do so a zookeeper has to be running and a remote metastore has to be
used . Is there a good doc that I can follow to configure both hive and
zookeeper to support concurrency? Thank you very much.
I found the problem and case solved.
Garry
From: Garry Chen [mailto:g...@cornell.edu]
Sent: Monday, August 03, 2015 5:01 PM
To: user@hive.apache.org
Subject: start hiveserver2 failed need help
Hi all,
When I try to start hiveserer2 failed with following error. It was
running but
Hi all,
When I try to start hiveserer2 failed with following error. It was
running but after the server reboot hiveeserver2 will not start. Please help.
Thank you very much.
Garry
2015-08-03 16:57:07,677 WARN [main]: server.HiveServer2
(HiveServer2.java:startHiveServer2(330))
Hi All,
Try to configure hiveserver2 metastore by using oracle. I can
start the metastore without problem but when try to start hiveserver2 I got
"2015-07-14 12:20:05,671 ERROR [main]: hive.log
(MetaStoreUtils.java:logAndThrowMetaException(1173)) - Got exception:
org.apache.th
Hi All,
I am trying to setup a remote metastore for Hive using Oracle.
The following is my steps and error message when try to start hive. Please
help and thank you very much.
Garry
1. Create a hive user in Oracle instance
2. Run hive-schema-0.14.0.oracle.sql as
Hi,
I am using hive-1.1.0. Is there a way to let the insert
overwrite local statement write to a given file name like syz.txt instead of
default name 0_0? Thank you very much for your input.
Garry
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 bindings.
S
14 matches
Mail list logo