2.2.2版本,加了version字段以后。brokerload失败。报std::bad_cast。
sr重建表也不行。
具体日志见文件sr_broker_log-错误.txt (1.4 KB)
相关sql broker_load-bad_cast-sql.txt (984 字节)
hive表结构:
| Column | Type |
|---|---|
| dev_id | varchar |
| kgid | bigint |
| plat_id | integer |
| version | varchar |
| event_id | varchar |
| event_time | bigint |
| room_id | bigint |
| entry_id | varchar |
| device_model | varchar |
| device_brand | varchar |
| p1 | varchar |
| p2 | varchar |
| p3 | varchar |
| dt | varchar |
| type | varchar |
sr表结构:
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| event_id | VARCHAR(65533) | Yes | true | None | |
| plat_id | INT | Yes | true | None | |
| kgid | BIGINT | Yes | true | None | |
| dev_id | VARCHAR(65533) | Yes | false | None | |
| version | VARCHAR(65533) | Yes | false | None | |
| event_time | BIGINT | Yes | false | None | |
| room_id | BIGINT | Yes | false | None | |
| entry_id | VARCHAR(65533) | Yes | false | None | |
| device_model | VARCHAR(65533) | Yes | false | None | |
| device_brand | VARCHAR(65533) | Yes | false | None | |
| p1 | VARCHAR(65533) | Yes | false | None | |
| p2 | VARCHAR(65533) | Yes | false | None | |
| p3 | VARCHAR(65533) | Yes | false | None | |
| dt | DATE | Yes | false | None | |
| type | VARCHAR(65533) | Yes | false | None |