dongjoon-hyun edited a comment on issue #23468: [SPARK-26535][SQL] Parse literals as DOUBLE instead of DECIMALS URL: https://github.com/apache/spark/pull/23468#issuecomment-451701676 Hi, @mgaido91 and @gatorsmile . First of all, Hive starts to use `Decimal` by default. Also, this introduces TPC-H query result difference among Spark versions. We cannot do this. I'm -1 for this. ```sql hive> select version(); OK 3.1.1 rf4e0529634b6231a0072295da48af466cf2f10b7 Time taken: 0.089 seconds, Fetched: 1 row(s) hive> explain select 2.3; OK STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: TableScan alias: _dummy_table Row Limit Per Split: 1 Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 2.3 (type: decimal(2,1)) outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: COMPLETE ListSink ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
