[ 
https://issues.apache.org/jira/browse/CARBONDATA-1774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

anubhav tarar reassigned CARBONDATA-1774:
-----------------------------------------

    Assignee: anubhav tarar  (was: Vandana Yadav)

> 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



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to