xxhZs commented on issue #33461: URL: https://github.com/apache/doris/issues/33461#issuecomment-2060514486
> But the event_timestamp_local column is datetime type instead of array type in my environment. > > mysql> select * from information_schema.columns where table_name like 'demo_bhv_table'; +---------------+--------------+----------------+-----------------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+-------------+------------+-------+------------+----------------+-------------+----------------+-----------------------+--------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT | COLUMN_SIZE | DECIMAL_DIGITS | GENERATION_EXPRESSION | SRS_ID | +---------------+--------------+----------------+-----------------------+------------------+--- -------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+-------------+------------+-------+------------+----------------+-------------+----------------+-----------------------+--------+ | internal | demo | demo_bhv_table | user_id | 1 | NULL | YES | int | NULL | NULL | 10 | 0 | NULL | NULL | NULL | int(11) | UNI | | | | 10 | 0 | NULL | NULL | | internal | demo | demo_bhv_table | target_id | 2 | NULL | YES | varchar | 2147483643 | 8589934572 | NULL | NULL | NULL | NULL | NULL | string | | | | | 2147483643 | NULL | NULL | NULL | | internal | demo | demo_bhv_table | event_timestamp_local | 3 | NULL | YES | datetime | NULL | NULL | 18 | 0 | NULL | NULL | NULL | datetime | | | | | NULL | 0 | NULL | NULL | +---------------+--------------+----------------+-----------------------+------------------+----------------+-------------+-----------+--------------------- -----+------------------------+-------------------+---------------+--------------------+--------------------+----------------+-------------+------------+-------+------------+----------------+-------------+----------------+-----------------------+--------+ sorry，The real create stmt is CREATE table demo_bhv_table( user_id int, target_id text, event_timestamp_local Array<datetime> ) UNIQUE KEY(user_id) DISTRIBUTED BY HASH(user_id) BUCKETS 1 PROPERTIES ( "replication_allocation" = "tag.location.default: 1" ); -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
