> 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
> Assignee: anubhav tarar
> 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
Locked
