yaooqinn edited a comment on issue #26520: [SPARK-29896][SQL] Extend typed literals support for all spark native types URL: https://github.com/apache/spark/pull/26520#issuecomment-554173105 # presto presto seems all supported ```sql presto> select int '1'; _col0 ------- 1 (1 row) Query 20191115_015007_00000_buer4, FINISHED, 1 node Splits: 17 total, 17 done (100.00%) 0:03 [0 rows, 0B] [0 rows/s, 0B/s] presto> select float '1'; Query 20191115_015020_00001_buer4 failed: line 1:8: Unknown type: float select float '1' presto> select float4 '1'; Query 20191115_015026_00002_buer4 failed: line 1:8: Unknown type: float4 select float4 '1' presto> select bigint '1'; _col0 ------- 1 (1 row) Query 20191115_015057_00003_buer4, FINISHED, 1 node Splits: 17 total, 17 done (100.00%) 0:00 [0 rows, 0B] [0 rows/s, 0B/s] presto> select smallint '1'; _col0 ------- 1 (1 row) Query 20191115_015105_00004_buer4, FINISHED, 1 node Splits: 17 total, 17 done (100.00%) 0:00 [0 rows, 0B] [0 rows/s, 0B/s] presto> select real '1'; _col0 ------- 1.0 (1 row) Query 20191115_015115_00005_buer4, FINISHED, 1 node Splits: 17 total, 17 done (100.00%) 0:00 [0 rows, 0B] [0 rows/s, 0B/s] presto> select bool '1'; Query 20191115_015126_00006_buer4 failed: line 1:8: Unknown type: bool select bool '1' presto> select boolean '1'; _col0 ------- true (1 row) Query 20191115_015128_00007_buer4, FINISHED, 1 node Splits: 17 total, 17 done (100.00%) 0:00 [0 rows, 0B] [0 rows/s, 0B/s] ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to 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]
