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

CLI: Display column data types in CLI table #3895

Closed
prrao87 opened this issue Jul 21, 2024 · 0 comments · Fixed by #3936
Closed

CLI: Display column data types in CLI table #3895

prrao87 opened this issue Jul 21, 2024 · 0 comments · Fixed by #3936
Assignees
Labels
cli feature New features or missing components of existing features

Comments

@prrao87
Copy link
Member

prrao87 commented Jul 21, 2024

API

Other

Description

Related to #3894 (these could both be addressed together - imo, the aesthetics of the table in the CLI would need to be improved before the types are displayed).

This is how a LOAD FROM currently outputs a table in the Kùzu CLI. We do not show the data types that are in each column, and for things like dates and booleans, it would help to know from the table output what types Kùzu sees them as.

kuzu> LOAD FROM 'test_data.csv' (header=true) RETURN *;
---------------------------------------------------------------------------
| id | amount   | counts | birthdate  | is_valid | comment                |
---------------------------------------------------------------------------
| 1  | 3.635742 | 89     | 1990-01-01 | true     | This is a test.        |
---------------------------------------------------------------------------
| 2  | 9.381905 | 57     | 2001-03-27 | false    | This is another test.  |
---------------------------------------------------------------------------
(2 tuples)
(6 columns)

Here's how it looks in the DuckDB CLI (shows the data types clearly).

D SELECT * FROM test_data.csv;
┌───────┬──────────┬────────┬────────────┬──────────┬────────────────────────┐
│  id   │  amount  │ counts │ birthdate  │ is_valid │        comment         │
│ int64 │  double  │ int64  │    date    │ boolean  │        varchar         │
├───────┼──────────┼────────┼────────────┼──────────┼────────────────────────┤
│     1 │ 3.635742 │     89 │ 1990-01-01 │ true     │ This is a test.        │
│     2 │ 9.381905 │     57 │ 2001-03-27 │ false    │ This is another test.  │
└───────┴──────────┴────────┴────────────┴──────────┴────────────────────────┘
@prrao87 prrao87 added feature New features or missing components of existing features cli labels Jul 21, 2024
@MSebanc MSebanc self-assigned this Jul 22, 2024
@MSebanc MSebanc mentioned this issue Jul 24, 2024
1 task
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
cli feature New features or missing components of existing features
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants