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

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

Data type

Table engine

Format

Setting

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

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

Database

Table