Vandana Yadav created CARBONDATA-1774:
-----------------------------------------
Summary: Not able to fetch data from a table with Boolean data
type in presto
Key: CARBONDATA-1774
URL: https://issues.apache.org/jira/browse/CARBONDATA-1774
Project: CarbonData
Issue Type: Bug
Components: presto-integration
Affects Versions: 1.3.0
Environment: spark 2.1
Reporter: Vandana Yadav
Priority: Minor
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
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
