[ 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 # load data # filter: including >=,=,<=,<,=,!= # describle: should show boolean data type # 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. Boolean data type column can be added to dimension and use single-byte to store in carbon file. CarbonData should support boolean data type in following aspects: # create table # insert into table values and select # load data # filter > 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: 12h 10m > Remaining Estimate: 227h 50m > > 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 > # -- This message was sent by Atlassian JIRA (v6.4.14#64029) |
Free forum by Nabble | Edit this page |