[ 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