No data about SELECT queries in Superset in ClickHouse table system.processes about superset HOT 6 OPEN

I don't think this is something we can fix in Superset, it's not doing anything special with Select queries.

from superset.

@rusackas - I think ticket could be closed. The problem will not be fixed on Superset (#28007 (comment)) neither on ClickHouse (ClickHouse/ClickHouse#62604 (comment)) side. Fortunately we have a workaround.

About Documentation PR... Is this suggestion to me? I think this info is useless on this page. If anyone will have this problem he/she will googling and find this post.

from superset.

I received workaround for this issue from @den-crane - ClickHouse/ClickHouse#62604 (comment)

TLDR: add sleep(1) to SELECT query. So, instead this "SELECT * FROM t" I should write this: "SELECT sleep(1),* FROM t"

from superset.

OK, I fixed it with workaround:

1. in superset/sql_lab.py add this:
   import re -- row №25

sql = add_sleep_to_selects_in_sql(sql) -- row №264 in execute_sql_statement before 'try: query.executed_sql = sql'

def add_sleep_to_selects_in_sql(
    sql: str
) -> str:
    if (    (re.search(r"\bINSERT\b", sql, flags=re.IGNORECASE) == None) 
        and (re.search(r"\bUPDATE\b", sql, flags=re.IGNORECASE) == None) 
        and (re.search(r"\bDELETE\b", sql, flags=re.IGNORECASE) == None)):
        return re.sub(r"\bSELECT\b", "SELECT sleep(1), ", sql, flags=re.IGNORECASE)

    return sql

-- row №324

2. in superset/result_set.py add this:

            if "sleep(1)" in column_names:
                column_names.remove("sleep(1)")
                for i, s in enumerate(data):
                    data[i] = s[1:]

-- row №123 in class SupersetResultSet before comment '# fix cursor descriptor with the deduped names'

from superset.

If we have a workaround and can't fix this in Superset, we should probably close it. Before I/we do, would anyone want to open a Documentation PR (or at least suggestion) on this page to help others?

from superset.

Right @berlicon - I think you (or anyone who understands this issue) would be helping others by making a change on that page, if it's "useless". The more we document rather than have people go fishing through issues, the better.

from superset.