| --! qt:disabled:HIVE-24816 |
| --! qt:dataset:alltypesorc |
| SET hive.ctas.external.tables=true; |
| SET hive.external.table.purge.default = true; |
| CREATE EXTERNAL TABLE druid_alltypesorc_n0 |
| STORED BY 'org.apache.hadoop.hive.druid.QTestDruidStorageHandlerToAddFaultyHost' |
| TBLPROPERTIES ("druid.segment.granularity" = "HOUR", "druid.query.granularity" = "MINUTE") |
| AS |
| SELECT cast (`ctimestamp2` as timestamp with local time zone) as `__time`, |
| cstring1, |
| cdouble, |
| cfloat, |
| ctinyint, |
| csmallint, |
| cint, |
| cbigint, |
| cboolean1 |
| FROM alltypesorc where ctimestamp2 IS NOT NULL; |
| |
| DESCRIBE druid_alltypesorc_n0; |
| |
| DESCRIBE extended druid_alltypesorc_n0; |
| |
| SELECT COUNT(*) FROM druid_alltypesorc_n0; |
| |
| ALTER TABLE druid_alltypesorc_n0 ADD COLUMNS (cstring2 string, cboolean2 boolean, cint2 int); |
| |
| DESCRIBE druid_alltypesorc_n0; |
| |
| DESCRIBE extended druid_alltypesorc_n0; |
| |
| SELECT COUNT(*) FROM druid_alltypesorc_n0 WHERE cstring2 IS NOT NULL; |
| |
| INSERT INTO TABLE druid_alltypesorc_n0 |
| SELECT cast (`ctimestamp1` as timestamp with local time zone) as `__time`, |
| cstring1, |
| cdouble, |
| cfloat, |
| ctinyint, |
| csmallint, |
| cint, |
| cbigint, |
| cboolean1, |
| cstring2, |
| cboolean2, |
| cint |
| FROM alltypesorc where ctimestamp1 IS NOT NULL; |
| |
| |
| SELECT COUNT(*) FROM druid_alltypesorc_n0; |
| |
| SELECT COUNT(*) FROM druid_alltypesorc_n0 WHERE cstring2 IS NULL; |
| |
| SELECT COUNT(*) FROM druid_alltypesorc_n0 WHERE cstring2 IS NOT NULL; |
| |
| DROP TABLE druid_alltypesorc_n0; |