Hi,
Can I please have write access to the Hive wiki? I'm writing per the
instructions here:
https://cwiki.apache.org/confluence/display/Hive/AboutThisWiki.
Thanks,
Eric
Sorry for the big bomb. I tried my best to simplify the query to this:
*SELECT T1.a, T1.b FROM T1
LEFT SEMI JOIN T9 ON T1.a=T9.a AND T1.b=T9.b
LEFT OUTER JOIN T10 ON T1.a = T10.a AND T1.b = T10.b
WHERE T1.b <> '0202';*
Basically, without the last where clause, everything is fine. But why does
Hello,
I am using Hive to analyze some data. As part of my hive queries I am trying
to do Distinct select on different columns and I am not able to get that well.
I am performing explode on data as its type is array. I am not able to
Select DISTINCT (lateral_test.id, lateral_test.person.date
Hi:
Check LOG4J log file (Usaually, it is in /tmp/hive/hive.log or
/tmp/${LOGNAME}/hive.log) for more details on the reason for the failure to
instantiate HiveMetaStore client.
If the MySQLConnection was stale due to long pause, try adding
'autoReconnect=true' option to the MySQL url
>
Thanks. It worked for me now when i use it as an empty string.
From: Krishnan K
To: "user@hive.apache.org" ; Raj Hadoop
Sent: Thursday, October 17, 2013 11:11 AM
Subject: Re: Hive Query Questions - is null in WHERE
For string columns, null will be interpr
Thanks Rinku, Nick, Rommel, and Eric,
I think I have other issues with MySQL.. Anyway, I've got another
more important fire to put out. I'll take this up again later..
Clay McDonald
From: Garg, Rinku [mailto:rinku.g...@fisglobal.com]
Sent: Thursday, October 17, 2013 10:03 AM
To: us
For string columns, null will be interpreted as an empty string and for
others, it will be interpreted as null...
On Wednesday, October 16, 2013, Raj Hadoop wrote:
> All,
>
> When a query is executed like the below
>
> select field1 from table1 where field1 is null;
>
> I am getting the resul
Hi,
Try this also in hive-site
javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
Driver class name for a JDBC metastore
Thanks & Regards,
Rinku Garg
From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com]
Sent: 17 October 2013 18:53
To: 'user@hive.apache.org'; 'nimar...
Remove this file /tmp/hive/hive.log and try again using hdfs user.
Thanks & Regards,
Rinku Garg
From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com]
Sent: 17 October 2013 19:09
To: Garg, Rinku
Cc: user@hive.apache.org
Subject: RE: Problem starting Hive
Hi Rinku, I tried running hive as th
Hi Rinku, I tried running hive as the root user and hdfs user, both failed. I
didn’t create a hive user. I’m using the sqladmin user to connect to the
metastore in the config file.
From: Garg, Rinku [mailto:rinku.g...@fisglobal.com]
Sent: Thursday, October 17, 2013 9:32 AM
To: user@hive.apache.
Hi,
Are you logged in using hive specific user or as root user.
/tmp/hive/hive.log file may be created once root user and it can’t be updated
by any other user so it says permission denied.
Thanks & Regards,
Rinku Garg
From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com]
Sent: 17 Octo
Yep..
[root@bigdata5 ~]# find / -type f -name mysql-connector-java*
/usr/lib/hive/lib/mysql-connector-java-5.1.24-bin.jar
/usr/share/java/mysql-connector-java-5.1.17.jar
From: Rommel Garcia [mailto:rgar...@hortonworks.com]
Sent: Thursday, October 17, 2013 9:24 AM
To: Clay McDonald
Cc: Eric Miz
It looks good to me...
javax.jdo.option.ConnectionURL
jdbc:mysql://bigdata5.bateswhite.com:3306/hadoop
JDBC connect string for a JDBC metastore
javax.jdo.option.ConnectionDriverName
sqladmin
Driver class name for a JDBC metastore
javax.jdo.option.ConnectionPassword
password
Ente
Nick, let me check...
From: Martin, Nick [mailto:]
Sent: Thursday, October 17, 2013 9:00 AM
To: user@hive.apache.org
Subject: RE: Problem starting Hive
Hi Clay,
Quick housekeeping/config check...is the URI in /etc/hive/conf/hive-site.xml
pointing to the right place?
From: Clay McDonald [mailt
Thanks Eric! My Hive log is attached.
From: Eric Mizell [mailto:emiz...@hortonworks.com]
Sent: Thursday, October 17, 2013 8:59 AM
To: Clay McDonald
Cc: Rommel Garcia; Yi Zhang; user@hive.apache.org; Chris Hackett; Steve
Puckett; Clay McDonald; Terry Padgett
Subject: Re: Problem starting Hive
Cl
Hi Clay,
Quick housekeeping/config check...is the URI in /etc/hive/conf/hive-site.xml
pointing to the right place?
From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com]
Sent: Thursday, October 17, 2013 8:54 AM
To: 'Eric Mizell'; Rommel Garcia; Yi Zhang; 'user@hive.apache.org'
Cc: Chris Hac
This query should be broken down so that each piece of the query can be tested.
Start by running it with just one join condition, then expand it to two joins
and so on, this will help you isolate the issue.
Clay
From: Nitin Pawar [mailto:nitinpawar...@gmail.com]
Sent: Thursday, October 17, 201
Good morning all, I have another issue this morning. This time with Hive. Hive
was working before I restarted the server. My metastore is MySQL on the same
server. See error below;
[root@bigdata5 staff]# hive
13/10/16 12:31:18 WARN conf.Configuration: mapred.max.split.size is deprecated.
Instea
Echoing wat Ed said,
its too hard to understand a 2 page query over an email .. so may be
something like
select * from (select blah from abc where condition)a join (select blah
from xyz where condition)b on (blah) where condition may help to understand
On Thu, Oct 17, 2013 at 2:51 PM, Ed Soniat
Would it be possible to simply this query removing as much as possible
keeping just enough to demonstrate the where issue.
On Wed, Oct 16, 2013 at 2:22 PM, Xiu Guo wrote:
> The following query does not work:
>
> SELECT
>
> T1.ACCOUNT_NUM
>
> ,T1.ACCOUNT_MODIFIER_NUM
>
> ,T1.DEPOSIT_TYPE_CD
>
>
Thanks, Nitin, I guess, as you suggested. I can use text format in temp
table (staging table), and use final table as ORC format. So when I merge
data from staging table to final table, data got re-formatted from text
into ORC.
Johnny
On Wed, Oct 16, 2013 at 11:46 PM, Nitin Pawar wrote:
> Hi Zh
21 matches
Mail list logo
