Lightning: parse bit string exported as Parquet from Aurora error
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Bug Report
Please answer these questions before submitting your issue. Thanks!
### 1. Minimal reproduce step (Required)
1. export table with schema from Aurora:
```
CREATE TABLE jxtest(
`id` char(36) NOT NULL,
`a` bigint unsigned NOT NULL,
`aa` bigint signed NOT NULL,
`b` int(11) unsigned NOT NULL,
`bb` int(11) signed NOT NULL,
`c` smallint signed NOT NULL,
`cc` smallint unsigned NOT NULL,
`d` tinyint signed NOT NULL,
`dd` tinyint unsigned NOT NULL,
`e` float unsigned NOT NULL,
`ee` float signed NOT NULL,
`f` VARCHAR(30) NOT NULL,
`ff` TEXT NOT NULL,
`h` MEDIUMTEXT NOT NULL,
`hh` LONGTEXT NOT NULL,
`ii` TINYTEXT NOT NULL,
`j` DECIMAL NOT NULL,
`jj` DECIMAL(8,0) NOT NULL,
`k` DECIMAL(8,8) NOT NULL,
`kk` DECIMAL(20,0) NOT NULL,
`l` DECIMAL(20,8) NOT NULL,
`ll` DECIMAL(36,0) NOT NULL,
`m` DECIMAL(36,8) NOT NULL,
`mm` DATE NOT NULL,
`n` TIME NOT NULL,
`nn` YEAR NOT NULL,
`o` DATETIME NOT NULL,
`oo` BINARY NOT NULL,
`p` BLOB NOT NULL,
`pp` LONGBLOB NOT NULL,
`q` MEDIUMBLOB NOT NULL,
`qq` TINYBLOB NOT NULL,
`rr` BIT NOT NULL,
`s` BOOLEAN NOT NULL,
`ss` DOUBLE signed NOT NULL,
`t` DOUBLE unsigned NOT NULL,
PRIMARY KEY ( `id` ),
KEY `index_a` (`a`) );
```
2. import parquet using lightning
### 2. What did you expect to see? (Required)
All data the same as that in Aurora
### 3. What did you see instead (Required)
diff:
for binary type,
In Aurora: b'111111111'
In TiDB: 0x31313131313131313131
### 4. What is your TiDB version? (Required)
TiDB: v6.2.0
Lighting: v6.2.0
Contributor guide
Assessment
This issue has not been assessed yet.