3 ms·
Just had to try: $ function _select_aux () { clickhouse local -q "SELECT $* FORMAT Pretty" } $ alias SELECT='noglob _select_aux' $ SELECT COUNT(*) as cou
by wwader 3y ago
Just had to try:
$ function _select_aux () { clickhouse local -q "SELECT $* FORMAT Pretty" }
$ alias SELECT='noglob _select_aux'
$ SELECT COUNT(*) as count FROM file('repos.json', JSON)
┏━━━━━━━┓
┃ count ┃
┡━━━━━━━┩
│ 30 │
└───────┘
- xk3 3y agoThis is very nice!! I went down the format clause[1] rabbit hole a couple minutes ago and it looks like they have `FORMAT Markdown` as an option. FORMAT PrettySpaceNoEscapes also looks a bit better than Pretty or the default PrettyCompact imho 1. https://clickhouse.com/docs/en/interfaces/formats https://clickhouse.com/docs/en/interfaces/formats
- Something1234 3y agoWhere's this noglob command coming from? I haven't heard of it before.
- wwader 3y agoAh sorry that is probably zsh specific, it makes sure to not glob expand * etc