A join between bigint and string might actually be evaluated by converting both
values to a double .. try doing an EXPLAIN of the query, that might show what
conversion is being done for the join keys.
If that is the case, you could try explicitly casting the join keys to either
string or
No, The join columns are ("bigint" and "string").
Yong
Subject: RE: Hive 0.12 MAPJOIN hangs sometimes
From: pjayachand...@hortonworks.com
To: user@hive.apache.org; user@hive.apache.org
Date: Fri, 11 Mar 2016 15:48:52 +
Is the join column of type double? If so there is a known issue
I believe this is an issue in the Storm Hive bolt. I don’t have an Apache JIRA
on it, but if you ask on the Hortonworks lists we can connect you with the fix
for the storm bolt.
Alan.
> On Mar 10, 2016, at 04:02, Igor Kuzmenko wrote:
>
> Hello, I'm using Hortonworks Data
Hi, Hive users:
Currently our Hadoop vendor comes with Hive 0.12. I know it is a kind of old
version, but upgrade still has some long path to go.
Right now, we are facing an issue in the Hive 0.12.
We have one ETL kind of steps implemented in Hive, and due to the data volume
in this step, we
This one seems related
https://issues.apache.org/jira/browse/YARN-4538
Yet to ascertain if it actually fixes this issue.
On Thu, Mar 10, 2016 at 11:43 PM, Gopal Vijayaraghavan
wrote:
>
> > This seems to be something YARN fair-scheduler reporting it this way..
> >although
yes you can
Register table in hive based in hbase
CREATE EXTERNAL TABLE IF NOT EXISTS DB_NAME.TABLE_NAME(COL1 STRING,COL2
STRING,COL3 STRING)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:COL2,cf:COL3")
TBLPROPERTIES
Hi,
I have a HBase table with rowkey and column family.
Is it possible to map HBase table to hive table?
Thanks