Raj Thapar created HIVE-7471:
--------------------------------
Summary: testing for equality of decimal columns does not work
Key: HIVE-7471
URL: https://issues.apache.org/jira/browse/HIVE-7471
Project: Hive
Issue Type: Bug
Components: Database/Schema
Environment: x86_64 x86_64 x86_64 GNU/Linux
Reporter: Raj Thapar
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')
--
This message was sent by Atlassian JIRA
(v6.2#6252)
