[ https://issues.apache.org/jira/browse/CARBONDATA-1444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xubo245 updated CARBONDATA-1444: -------------------------------- Description: Spark/Hive table support Boolean data type, the internal table also should support Boolean data type. Boolean data type Range: TRUE or FALSE. Do not use quotation marks around the TRUE and FALSE literal values. You can write the literal values in uppercase, lowercase, or mixed case. The values queried from a table are always returned in lowercase, true or false. In implementing this function, we employ: # endcoding: RLE # data expression: byte array CarbonData should support boolean data type in following aspects: # create table: support Boolean data type # insert into table values: support insert Boolean column # insert overwrite # insert into table select from another table # select from a table # load data: from a local csv file # filter: including >=, >, =, <=, <, =, !=, in, not in # describle: should show boolean data type We also add some test cases in booleantype directory of spark2 was: Spark/Hive table support Boolean data type, the internal table also should support Boolean data type. Boolean data type Range: TRUE or FALSE. Do not use quotation marks around the TRUE and FALSE literal values. You can write the literal values in uppercase, lowercase, or mixed case. The values queried from a table are always returned in lowercase, true or false. In implementing this function, we employ: # endcoding: RLE # data expression: byte array CarbonData should support boolean data type in following aspects: # create table: support Boolean data type # insert into table values: support insert Boolean column # insert overwrite # insert into table select from another table # select # load data # filter: including >=,=,<=,<,=,!= # describle: should show boolean data type # > CarbonData unsupport Boolean data type > -------------------------------------- > > Key: CARBONDATA-1444 > URL: https://issues.apache.org/jira/browse/CARBONDATA-1444 > Project: CarbonData > Issue Type: Improvement > Components: sql > Affects Versions: 1.2.0 > Reporter: xubo245 > Assignee: xubo245 > Priority: Minor > Fix For: 1.3.0 > > Original Estimate: 240h > Time Spent: 13.5h > Remaining Estimate: 226.5h > > Spark/Hive table support Boolean data type, the internal table also should support Boolean data type. > Boolean data type Range: TRUE or FALSE. Do not use quotation marks around the TRUE and FALSE literal values. You can write the literal values in uppercase, lowercase, or mixed case. The values queried from a table are always returned in lowercase, true or false. > In implementing this function, we employ: > # endcoding: RLE > # data expression: byte array > > CarbonData should support boolean data type in following aspects: > # create table: support Boolean data type > # insert into table values: support insert Boolean column > # insert overwrite > # insert into table select from another table > # select from a table > # load data: from a local csv file > # filter: including >=, >, =, <=, <, =, !=, in, not in > # describle: should show boolean data type > We also add some test cases in booleantype directory of spark2 -- This message was sent by Atlassian JIRA (v6.4.14#64029) |
Free forum by Nabble | Edit this page |