Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
1.3.0
-
None
-
spark 2.1
Description
Not able to fetch data from a table with Boolean data type in presto
Steps to Reproduce:
On Beeline
1)Create table:
create table boolean ( id int, employee boolean) stored by 'carbondata';
2) Insert values in table:
insert into boolean values (1,true);
insert into boolean values (2,false);
insert into boolean values (5,true);
insert into boolean values (3,true);
insert into boolean values (4,false);
3) Execute select query with and without boolean datatype;
a)select id from boolean;
output:
-----+
| id |
-----+
| 2 |
| 3 |
| 4 |
| 5 |
| 1 |
-----+
b)select employee from boolean;
output:
-----------
| employee |
-----------+
| false |
| true |
| true |
| false |
| true |
-----------+
c) select * from boolean;
output:
--------------
| id | employee |
--------------
| 1 | true |
| 3 | true |
| 4 | false |
| 5 | true |
| 2 | false |
--------------
On Presto CLI:
Execute queries with and without boolean data type:
a)select id from boolean;
output:
id
2
5
1
3
4
(5 rows)
b)select employee from boolean;
output:
Expected output: it should display the boolean data type values of employee column as on beeline.
Actual output:
Query 20171120_054640_00011_2ppsk, FAILED, 1 node
Splits: 21 total, 0 done (0.00%)
0:01 [0 rows, 0B] [0 rows/s, 0B/s]
Query 20171120_054640_00011_2ppsk failed: com.facebook.presto.spi.type.BooleanType
c)select * from boolean;
output:
Expected output: it should display the boolean data type values of employee column as on beeline.
Actual output:
Query 20171120_054858_00012_2ppsk, FAILED, 1 node
Splits: 21 total, 0 done (0.00%)
0:00 [0 rows, 0B] [0 rows/s, 0B/s]
Query 20171120_054858_00012_2ppsk failed: com.facebook.presto.spi.type.BooleanType
Attachments
Issue Links
- links to
