[ 
https://issues.apache.org/jira/browse/HIVE-2586?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13172864#comment-13172864
 ] 

jirapos...@reviews.apache.org commented on HIVE-2586:
-----------------------------------------------------



bq.  On 2011-12-19 21:21:20, Carl Steinbach wrote:
bq.  > ql/src/test/queries/clientpositive/compare_float_double.q, line 1
bq.  > <https://reviews.apache.org/r/3073/diff/2/?file=63280#file63280line1>
bq.  >
bq.  >     Please move these tests to ops_comparison.q. I don't think there's 
much benefit to adding a new data file with float data, and loading data into 
the table adds a lot of time to the test.
bq.  >     
bq.  >     Also, this only provides coverage for the changes in 
GenericUDFOPEqual. Please add coverage for the other operators that you 
modified.
bq.  
bq.  Navis Ryu wrote:
bq.      I thought for meaningful test column should be compared to 
constant/column instead of comparing constant to constant and I couldn't find 
any existing table contains float/double column. All agree on you except that.

Ok, in that case can you please add an "all_types" table that contains one 
column per primitive type (e.g. one float column, one int column, etc), and add 
code to QTestUtil so that this table is automatically created for each 
CliDriver test?


- Carl


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/3073/#review3982
-----------------------------------------------------------


On 2011-12-08 09:33:37, Navis Ryu wrote:
bq.  
bq.  -----------------------------------------------------------
bq.  This is an automatically generated e-mail. To reply, visit:
bq.  https://reviews.apache.org/r/3073/
bq.  -----------------------------------------------------------
bq.  
bq.  (Updated 2011-12-08 09:33:37)
bq.  
bq.  
bq.  Review request for hive, John Sichi and Carl Steinbach.
bq.  
bq.  
bq.  Summary
bq.  -------
bq.  
bq.  Is there any reason should not to implement comparing float/double?
bq.  
bq.  
bq.  This addresses bug HIVE-2586.
bq.      https://issues.apache.org/jira/browse/HIVE-2586
bq.  
bq.  
bq.  Diffs
bq.  -----
bq.  
bq.    data/files/floatdouble.txt PRE-CREATION 
bq.    ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g eecd9e7 
bq.    ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java 
59e55ae 
bq.    
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFBaseCompare.java 
3fb3879 
bq.    ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFOPEqual.java 
dc4670e 
bq.    
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFOPEqualOrGreaterThan.java
 f44f353 
bq.    
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFOPEqualOrLessThan.java
 7d74e82 
bq.    
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFOPGreaterThan.java 
47fceb1 
bq.    
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFOPLessThan.java 
12369a8 
bq.    
ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFOPNotEqual.java 
22b3bef 
bq.    ql/src/test/queries/clientpositive/compare_float_double.q PRE-CREATION 
bq.    ql/src/test/results/clientpositive/compare_float_double.q.out 
PRE-CREATION 
bq.  
bq.  Diff: https://reviews.apache.org/r/3073/diff
bq.  
bq.  
bq.  Testing
bq.  -------
bq.  
bq.  added test : compare_float_double.q
bq.  
bq.  
bq.  Thanks,
bq.  
bq.  Navis
bq.  
bq.


                
> Float comparison doesn't work
> -----------------------------
>
>                 Key: HIVE-2586
>                 URL: https://issues.apache.org/jira/browse/HIVE-2586
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Robert Surówka
>            Assignee: Navis
>            Priority: Minor
>             Fix For: 0.9.0
>
>         Attachments: HIVE-2586.1.patch.txt
>
>
> Create table with float column, insert to it e.g. 1410.1, and then do select 
> * from <that table> where <that column> = 1410.1 . Nothing will be found. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


Reply via email to