Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

map data type limitations #3915

Open
gaoboal opened this issue May 6, 2024 · 1 comment
Open

map data type limitations #3915

gaoboal opened this issue May 6, 2024 · 1 comment
Assignees
Labels
bug Something isn't working documentation Improvements or additions to documentation enhancement New feature or request execute-engine hybridse sql engine sql SQL standard. definition/revise for a SQL statement/clause etc

Comments

@gaoboal
Copy link
Collaborator

gaoboal commented May 6, 2024

Bug Description
test table: CREATE TABLE t1 (c1 string, c2 int, c3 MAP<string, string>);

  1. In the desc t1; statement, the key and value types of the map are not displayed.
  2. In the SHOW CREATE TABLE t1; statement, columns of type map are not displayed.
  3. In the SQL syntax documentation for table creation, the support for the map type is not specified. It is necessary to add support documentation for the map type and provide an example. https://openmldb.ai/docs/zh/main/openmldb_sql/ddl/CREATE_TABLE_STATEMENT.html
  4. After executing the statement INSERT INTO t1 VALUES ("1", 1, map(1, "12", 2, "100"));, a warning-level alert log is being displayed.
    insert into t1 values ("1", 1, map(1, "12", 2, "100"));
    W20240429 14:40:09.353835 19961 codec.cc:82] type is not supported
  5. In the SELECT * FROM t1; statement, the columns are displaying incorrectly or out of alignment.
    image
@gaoboal gaoboal added the bug Something isn't working label May 6, 2024
@aceforeverd
Copy link
Collaborator

Thanks

  1. In the desc t1; statement, the key and value types of the map are not displayed.
  2. In the SHOW CREATE TABLE t1; statement, columns of type map are not displayed.
  • desc or show create table do not handle map type
  1. In the SQL syntax documentation for table creation, the support for the map type is not specified. It is necessary to add support documentation for the map type and provide an example. https://openmldb.ai/docs/zh/main/openmldb_sql/ddl/CREATE_TABLE_STATEMENT.html

fixed by #3912

  1. After executing the statement INSERT INTO t1 VALUES ("1", 1, map(1, "12", 2, "100"));, a warning-level alert log is being displayed.
    insert into t1 values ("1", 1, map(1, "12", 2, "100"));
    W20240429 14:40:09.353835 19961 codec.cc:82] type is not supported
  • enhancement, not affect correctness
  1. In the SELECT * FROM t1; statement, the columns are displaying incorrectly or out of alignment.
    image

@aceforeverd aceforeverd added enhancement New feature or request execute-engine hybridse sql engine sql SQL standard. definition/revise for a SQL statement/clause etc documentation Improvements or additions to documentation labels May 6, 2024
@aceforeverd aceforeverd changed the title Issues with the new 'map' type in certain scenarios map data type limitations May 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working documentation Improvements or additions to documentation enhancement New feature or request execute-engine hybridse sql engine sql SQL standard. definition/revise for a SQL statement/clause etc
Projects
None yet
Development

No branches or pull requests

2 participants