tabixio/tabix

Tabix.io UI

tabix's Issues

Roadmap - Wishes, proposals and requirements

I suggest here to express all wishes and proposals - maybe they will be implemented in the near future

Предлагаю тут высказать все пожелания и хотелки - возможно они будут реализованы в ближайшее время

Draw error

(
SELECT number as ago_mins,
(ago_mins<60 AND ago_mins>1? ( 1 + (1 - ago_mins/60)/2 ) : 1) as oldes_factor
FROM system.numbers 
LIMIT 66
)
ORDER BY ago_mins

the tabix can't show table STRUCTURE and table data By the sidebar

i am newcomer to clickhouse.
i install 1.1.54236 clickhouse on my linux computer.
i use http://ui.tabix.io to connect my clickhouse.
it can query SQL , but can't show table structure and table data by the sidebar.
excuse me, can u tell me where is wrong?

Cделать сборку через electron app

• Native
  https://electron.atom.io/

Подсветка отставания реплики

Используем
system.replicas
system.replica_que

Error messages are displayed in Russian

What do you think about translate some error messages that are displayed in Russian?

I could help on this. :)

XSS via query

SELECT '<iframe src=x onload=alert()>' - may be shared via clickjacking to other users.

Статус

Проект живой?

CH without auth

With new tabix.io I can not connect to my clickhouse which configured without authorization. What can I do?

Sign in error in tabix with my company IP

Hi all,
I was trying to see data from clickhouse on tabix, so i opened tabix ui on browser and started entering credentials but it is asking me to check my ip,port.user name and password

and also if i do below command on my console it says ok....what might be the problem?

[root@AELAB110 ~]# curl 'http://localhost:8123/'
Ok.

Cmd-Left and Cmd-Right should move cursor to start and end of line in editor

When using OS X it is not possible to go to start or end of line in the SQL editor by
using Cmd-Left Arrow and Cmd-Right arrow
If this was implemented it would make the editor a lot easier to use with keyboard only

Docker compose failed

Cannot build project in docker compose.

bower d3 resolution Unsuitable resolution declared for d3: ~4.4.1
bower ECONFLICT Unable to find suitable version for d3
ERROR: Service 'api' failed to build: The command '/bin/sh -c npm install && bower install --allow-root && gulp build' returned a non-zero code: 1

RENAME sentences does not seem to be supported

When writing RENAME sentences I have observed they do not seem to be supported on Tabix. The syntax highlighting does not change the colour of words like RENAMEor TO. When they are executed the table list is not updated unlike it happens with DROPor CREATE TABLE. I have to refresh the whole page.

In this previous example you can se the syntax highlighting issue and the table name is not changed to purchases. I am using latest docker image spoonest/clickhouse-tabix-web-client

UI stuck on the circular links in sankey draw

When the data occasionally have a circles like this:

alice -> 5 -> bob
bob -> 4 -> alice

sankey diagram is stuck and kill the session. I would guess that it is a limitation of the sankey diagram by itself, but can you guys please check if there are any circles in a data before drawing and show some error dialog with the sample of the circle (SuperSet do it this this way. It reject to draw unless all circles resolved).

Render Array(x)

SELECT splitByChar('x','1x2x3x4')

CREATE TABLE ... AS SELECT uses "Max result rows" as if it was doing a SELECT

When I issue CREATE TABLE ... AS SELECT ... query and SELECT returns more rows than Max result rows configured in Tabix settings the query gets aborted with Code: 158, e.displayText() = DB::Exception: Limit for result rows exceeded: read 1003137 rows, maximum: 1000000, e.what() = DB::Exception error.

IMHO in case of CREATE... queries max_query_rows parameter should be skipped, or it should be set separately for DDL and for queries.

TABIX.SERVER problem

tabix Build 17.03.3
CH 1.1.54189

При попытке подключится к CH через TABIX.SERVER
Ошибка доступа.
Через DIRECT CH все ок.

Подробно:
Он шлет в clickhouse запрос
OPTIONS /query HTTP/1.1

на что тот отвечает
HTTP/1.1 501 Not Implemented

С чем это может быть свзяано?

Error with old version clickhouse

When I try to connect to clickhouse Version: 1.1.54112, I get error:

Unknown setting send_progress_in_http_headers

There is no property for disable this settings. Could you fix it?

XSS again

Hi.
Please look at the result of this code in tabix:

select "<script>alert('Hi, its me again!');</script>"

Quotes are incorrect, I know.

Parse problem with simple query

Hello!
I'm run follow queries on fresh ClickHouse server with using http://ui.tabix.io/sql:
CREATE DATABASE pc1;
CREATE TABLE t (a UInt8) ENGINE = Memory;
These commands are executed successfully.

Then, I execute the following query:
INSERT INTO t values (1), (2), (3);
And get the exception:

2017.04.07 18:58:45.112701 [ 10 ] executeQuery: Code: 27, e.displayText() = DB::Exception: Cannot parse input: expected ( before: /TABIX_QUERY_ID_ec0JCHn37U409iQ_()/: (at row 4)
, e.what() = DB::Exception (from 188.11.12.13:52766) (in query: INSERT INTO pc1.t values ),

This command, executed with clickhouse-client Is successful

I'm using
Server version 1.1.54198.
Chrome Version 57.0.2987.133 (64-bit) OSX

Make add_http_cors_header and log_queries optional

Hi, when using readonly in tabix it's impossible to login

Code: 164, e.displayText() = DB::Exception: Cannot override setting (add_http_cors_header) in readonly mode, e.what() = DB::Exception

But when I manually remove this flags from code all works good. That is why I have such proposition.
As for CORS headers, it could be simply added on nginx.

SQL results table header vs bottom horisontal scrollbar

Tabix.io Build 17.03.1 [20170323]
Chromium Browser Version 56.0.2924.76 Built on Ubuntu , running on LinuxMint 18.1 (64-bit)

After I run SQL query and make a look at result in a table below, I meet some inconvenience. Is it possible to keep both table header and bottom horizontal scrollbar on a results area? Situation is illustrated by two screenshots in attachment. Thanks!

Выгрузка в csv

Никак не могу найти кнопку выгрузки результата запроса в csv. Подскажите)
Спасибо!

Direct connection by IP address or host name faild

I deployed tabix on my own host. Then I tried to estabilish direct connect to CH by IP address as it is depicted bellow. I got error message but still it is possible to connect to local forwarded port 8123.

CH is avaliable via HTTP since command like

    curl 12.34.56.789:8123

returns Ok.

Render NULL

Render NULL value

SELECT 
    inf, 
    nan

Routing with # in url

Для встроенной "системы" (embedded ) которая загружается через /etc/clickhouse-server/config.xml

<!-- Default root page on http[s] server. For example load UI from https://tabix.io/ when opening http://localhost:8123 -->
 <!--
 <http_server_default_response><![CDATA[<html ng-app="SMI2"><head><base href="http://ui.tabix.io/"></head><body><div ui-view="" class="content-ui"></div><script src="http://loader.tabix.io/master.js"></script></body></html>]]></http_server_default_response>
 -->

1. Изменить route c /sql на #sql и т/д
2. Без правки в CH можно обойти ? Access to Font at 'http://ui.tabix.io/fonts/materialdesignicons-webfont.ttf?v=1.8.36' from origin 'http://xxxx:8123' has been blocked by CORS policy: No 'Access-Control-Allow-Origin'
3. В https://github.com/smi2/tabix.ui/blob/master/loader/master.js#L4 устанавливается признак что это embedded -> в интерфейсе входа сразу указать подходящий IP

Некорректное отображение больших цифр (на примере UInt64)

В примере запрос:
select toString(visit_id), visit_id
from visits
where visit_id = 18017313154537368237

Судя по toString(visit_id) - фильтрация проходит корректно, но отображение visit_id не верное.

Инициализация таблицы с колонкой Array(UInt64)

Найдено непонятное поведение в одном наверное редком случае.
Если создать ReplacingMergeTree таблицу с колонкой Array(UInt64) и вставить первые две строки с пустыми значениями в ней

CREATE TABLE test64 ( date Date, vers UInt64, attribute Array(UInt64) ) ENGINE = ReplacingMergeTree( date, ( vers ), 8192, vers)
INSERT INTO test64 (vers,attribute) VALUES (1,[]),(2,[])

...то таблица перестает отображаться в TABiX.
Т.е., например, на запрос

select * from test64

ответ не приходит и только переливается полоска процесса (".... select * from test64"). Этот же запрос в linux-клиенте отрабатывает нормально. В логах КХ ошибки не возникают.

При этом, если же хотя бы в одной из первых двух записей значение указать (включая значение 0), или поменять тип данных на, допустим, Array(UInt32), то все Ок.

Версия КХ 1.1.54343, но тоже самое было на ранних.

Show inf+nan

Не открывается таб DRAW в Chromium.

Привет! Спасибо за tabix.

Проблема в следующем: выполняю запрос, получаю ответ, пытаюсь открыть таб draw и в этот момент все виснит и через пару секунд страница падает с ошибкой "Aw, Snap! Something went wrong while displaying this webpage".

Chromium Version 57.0.2987.133 (64-bit)
Tabix.io Build 17.06.1 [20170614]

Если еще какая-то информация нужна, могу скинуть.

Mention chproxy in docs

chproxy provides the following features to tabix:

• chproxy may accept requests from readonly=1 users if allow_cors config is set. There is no need in add_http_cors_header hack.
• chproxy supports https out of the box, so tabix can send requests over untrusted networks without worrying that passwords may be intercepted.

Значение в в ответе меняется при копировании

Добрый вечер!

Значение в гриде с ответом меняется при копировании:

1. Вот сразу после выполнения селекта https://yadi.sk/i/oHTQw4XT3TyWaA
2. Попытался скопировать, значение поменялось на 3107276162941849000 https://yadi.sk/i/tliojJxo3TyWY8

Значение типа UInt64
Хром Версия 65.0.3325.181

AutoFormat error

If empty Ace.Editor - paste sql -> format -> error

Can TABIX draw Force-Directed Charts?

Can TABIX draw graph?
Can TABIX support Echarts Graph?

Docker version is not updated.

The version in docker hub is not last, please update.

Display query stats to the right of the results again

I liked the way the old version had put the queries performance stats at the right of the results tab. I know there is a Stats tab now, which is useful (and not always being updated), but the stats being displayed immediately with the results was very convenient :)

RO User Clickhouse option set wrong clickhouse http request

When checked RO User Clickhouse option
i have following error
http://take.ms/DAurd

beta: Клик по Settings генерирует событие Pinned на вкладках TABLE и DRAW

do we support elasticsearch?

do we support elasticsearch?

pivot + chart = TypeError

TypeError: Cannot read property 'format' of undefined

SELECT

block_ctr,count() as cnt
FROM 
(
SELECT
round(block_ctr,1) as block_ctr
FROM model.tmp_block_ctr 
WHERE block_ctr>0.1
)
GROUP BY block_ctr
ORDER BY block_ctr
LIMIT 40

pivot + chart

Tabix does not connect to host with path (http://host:80/admin/clickhouse_proxy/)

Does not connect to host with path (http://host:80/admin/clickhouse_proxy/)
The root cause of bug: connection url is converted to http://host:80/admin/clickhouse_proxy/:8123 (added 8123 as default port)
https://github.com/smi2/tabix.ui/blob/master/src/app/services/api.js#L42

Ошибка ERR_RESPONSE_HEADERS_TOO_BIG

Выполняю запрос в консоле select count(distinct (ID)) from T - возвращает 1 запись
Выполняю запрос через tabix
Failed to load resource: net::ERR_RESPONSE_HEADERS_TOO_BIG

Нормальные хоткеи.

Всё круто, но я уже полчаса не могу разобраться как мне выполнить SELECT 1;

Hot keys
⌘ + Enter

Exec current query
⌘ + Shift + Enter

Exec all query
⌘ + Y

Drop current line
⌘ + ⇧ + F

Reformat
⌘ + ⇧ + Plus|Minus

свернуть все/развернуть

Что это такое ⌘ ?! У менять нет такой кнопки на клавиатуре.
Перепробовал все возможные сочетания Shift, Ctrl, Alt +Enter. Ничего не работат!
Может SELECT 1 это вообще что-то не валидное, я не знаю, или это только на Маке работает?

WITH TOTALS LIMIT 2 FORMAT CSV

https://monosnap.com/file/NMBhCOzfvbU313AhrltHDFUfkfJ3WF

Very laggy

I'm sorry I don't know what else to provide other than the below. I used the original app a few months ago at http://guiclickhouse.smi2.ru and it was responsive. The new app at http://guiclickhouse.smi2.ru and this tabix.ui seem very laggy now. I have a number of tabs open with other SPA's and this app usually takes 20-50% cpu.

Intel i7
Windows 10
Chrome 57.0.2987.133

dictionaries.ads.blocks

Need dictionaries."ads.blocks"

window.global_tabix_default_settings

Support default settings for connect

Use Basic Authentication Instead of Query Params

RE: https://github.com/smi2/tabix.ui/blob/e238181b55039597ad7cee2e44c8322b59060ff6/src/app/services/api.js#L173-L178

The current code appends the username & password as URL query params, which puts the plaintext password at (high) risk of being logged in web-server logs.

• The Clickhouse HTTP interface supports HTTP Basic Authentication, and thus we should use this instead.
• This does mean that the server/proxies will need to return an "Access-Control-Allow-Origin" header, as adding an Authorization header (or any other header) no longer allows the requests to be simple requests, and thus browsers enforce CORS policies.

I'm looking at modifying Tabix to work in two ways:

• In the case where a username + password are supplied, use Basic Auth
• If only a username is supplied (no password), use query params

Results on the right are cut off by scroll bar

In the results table the last column is cut off by a scroll bar. When in full screen this doesn't happen.

Orange and Yellow colors in Style menu are Green

Errors are in these two lines:

tabix/src/app/draw/handtable.js

Line 706 in ee1116a

key: "style:green"

tabix/src/app/draw/handtable.js

Line 713 in ee1116a

key: "style:green"