CLI auto complete

Static suggestion

Parser keywords

  • ByteHouse CLI uses a parser to accurately suggest keywords

    • Use the tab or arrow keys to select and auto-complete your intended action

    • Press enter/return to execute the query directly. Press the spacebar to complete the SQL command

1280

Built-in functions

  • As there are a lot of built-in functions in the gateway, auto-complete will be triggered after you type 2 or more characters

  • The function's signature is also displayed

1280

Data type

1280

Table engine

1280

Format

1280

Setting

  • Attempts to resolve all settings from the server from the start
1280

Dynamic suggestion

Dynamic suggestion invocation requires querying in the background by the bytehouse-cli. To turn off dynamic suggestions, you can add the flag --disable_background or -db.

Warehouse

1280

Database

1280

Table

1280