[jira] [Created] (CARBONDATA-1774) Not able to fetch data from a table with Boolean data type in presto

[Akash R Nilugal (Jira)]

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)