tabixio / tabix Goto Github PK
View Code? Open in Web Editor NEWTabix.io UI
Home Page: https://tabix.io
License: Other
Tabix.io UI
Home Page: https://tabix.io
License: Other
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.
I'm looking at modifying Tabix to work in two ways:
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.
With new tabix.io I can not connect to my clickhouse which configured without authorization. What can I do?
Support default settings for connect
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.
SELECT splitByChar('x','1x2x3x4')
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.
Проблема в следующем: выполняю запрос, получаю ответ, пытаюсь открыть таб 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]
Если еще какая-то информация нужна, могу скинуть.
Добрый вечер!
Значение в гриде с ответом меняется при копировании:
Значение типа UInt64
Хром Версия 65.0.3325.181
Errors are in these two lines:
tabix/src/app/draw/handtable.js
Line 706 in ee1116a
tabix/src/app/draw/handtable.js
Line 713 in ee1116a
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
С чем это может быть свзяано?
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
Найдено непонятное поведение в одном наверное редком случае.
Если создать 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, но тоже самое было на ранних.
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?
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.If empty Ace.Editor - paste sql -> format -> error
do we support elasticsearch?
When checked RO User Clickhouse option
i have following error
http://take.ms/DAurd
Всё круто, но я уже полчаса не могу разобраться как мне выполнить 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
это вообще что-то не валидное, я не знаю, или это только на Маке работает?
SELECT '<iframe src=x onload=alert()>' - may be shared via clickjacking to other users.
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
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
I suggest here to express all wishes and proposals - maybe they will be implemented in the near future
Предлагаю тут высказать все пожелания и хотелки - возможно они будут реализованы в ближайшее время
Выполняю запрос в консоле select count(distinct (ID)) from T - возвращает 1 запись
Выполняю запрос через tabix
Failed to load resource: net::ERR_RESPONSE_HEADERS_TOO_BIG
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?
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.
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).
Need dictionaries."ads.blocks"
Проект живой?
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
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!
Для встроенной "системы" (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>
-->
/sql
на #sql
и т/д(
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 version in docker hub is not last, please update.
Hi.
Please look at the result of this code in tabix:
select "<script>alert('Hi, its me again!');</script>"
Quotes are incorrect, I know.
Никак не могу найти кнопку выгрузки результата запроса в csv. Подскажите)
Спасибо!
What do you think about translate some error messages that are displayed in Russian?
I could help on this. :)
Can TABIX draw graph?
Can TABIX support Echarts Graph?
Используем
system.replicas
system.replica_que
Render NULL value
SELECT
inf,
nan
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 RENAME
or TO
. When they are executed the table list is not updated unlike it happens with DROP
or 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
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.