Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
x86_64 x86_64 x86_64 GNU/Linux
Description
I am using Hive version 0.11 and am facing following problem,
I have 2 tables: venus_all_min_prices and venus_all_prices. They have a column bp_price_paid having type of decimal. When I try to query for equality on this column between 2 tables, I don't get any results. However if I use one specific value and use 2 conditions against this value (one for each column anded together), it does return results.
ie
1. venus_all_min_prices.bp_price_paid = venus_all_prices.bp_price_paid does not return any values
2. venus_all_min_prices.bp_price_paid = 59.99 and venus_all_prices.bp_price_paid = 59.99: returns results
What should I do to make (1) work?
My table definitions are below:
CREATE TABLE venus_all_min_prices(
bp_price_paid decimal,
opr_sty_clr_cd string)
PARTITIONED BY (
partition_timestamp string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
'hdfs://host:8020/user/user/database/temp_data_location/venus_all_min_prices'
TBLPROPERTIES (
'numPartitions'='1',
'numFiles'='1',
'transient_lastDdlTime'='1406040417',
'numRows'='0',
'totalSize'='2507',
'rawDataSize'='0')
CREATE TABLE venus_all_prices(
bp_price_paid decimal,
ord_key bigint,
oms_ord_ln_key string,
opr_sty_clr_cd string)
PARTITIONED BY (
partition_timestamp string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
'hdfs://host:8020/user/user/database/temp_data_location/venus_all_prices'
TBLPROPERTIES (
'numPartitions'='3',
'numFiles'='11',
'transient_lastDdlTime'='1405979150',
'numRows'='0',
'totalSize'='4845600',
'rawDataSize'='0')