Apache Superset不加载表记录/列

Question

我正试图在Superset中添加一个表。其他表被正确地添加，这意味着由Superset正确地获取列。但是对于我的表booking_xml，它不加载任何列。

表的描述是

​

添加此表后，当我单击表名来查看它时，它会产生以下错误

Empty query?
Traceback (most recent call last):
  File "/home/superset/superset_venv/lib/python3.8/site-packages/superset/viz.py", line 473, in get_df_payload
    df = self.get_df(query_obj)
  File "/home/superset/superset_venv/lib/python3.8/site-packages/superset/viz.py", line 251, in get_df
    self.results = self.datasource.query(query_obj)
  File "/home/superset/superset_venv/lib/python3.8/site-packages/superset/connectors/sqla/models.py", line 1139, in query
    query_str_ext = self.get_query_str_extended(query_obj)
  File "/home/superset/superset_venv/lib/python3.8/site-packages/superset/connectors/sqla/models.py", line 656, in get_query_str_extended
    sqlaq = self.get_sqla_query(**query_obj)
  File "/home/superset/superset_venv/lib/python3.8/site-packages/superset/connectors/sqla/models.py", line 801, in get_sqla_query
    raise Exception(_("Empty query?"))
Exception: Empty query?
ERROR:superset.viz:Empty query?

但是，当我尝试使用SQL编辑器探索它时，它会正确地加载。我发现在从表页面和从SQL编辑器加载时，form_data参数在URL中存在差异。

来自SQL视图的URL：

form_data={"queryFields":{"groupby":"groupby","metrics":"metrics"},"datasource":"192__table","viz_type":"table","url_params":{},"time_range_endpoints":["inclusive","exclusive"],"granularity_sqla":"created_on","time_grain_sqla":"P1D","time_range":"Last+week","groupby":[],"metrics":["count"],"all_columns":[],"percent_metrics":[],"order_by_cols":[],"row_limit":10000,"order_desc":true,"adhoc_filters":[],"table_timestamp_format":"smart_date","color_pn":true,"show_cell_bars":true}

来自数据集列表的URL：

form_data={"queryFields":{"groupby":"groupby","metrics":"metrics"},"datasource":"191__table","viz_type":"table","url_params":{},"time_range_endpoints":["inclusive","exclusive"],"time_grain_sqla":"P1D","time_range":"Last+week","groupby":[],"all_columns":[],"percent_metrics":[],"order_by_cols":[],"row_limit":10000,"order_desc":true,"adhoc_filters":[],"table_timestamp_format":"smart_date","color_pn":true,"show_cell_bars":true}

当从数据集列表加载时，/探索者_json/给出400坏请求。超集版本== 0.37.1，Python == 3.8

Answer 1

Superset保存必须连接的表的详细信息/元数据。所以，在我的表中有一个非常长的数据类型，正如您在所讨论的图像中所看到的那样。Superset将其保存为32长度的varchar。因此，数据库不允许将此值输入数据库。这导致了错误。因此，即使在数据源中添加表之后，也不会获取任何记录。

我所做的是增加列数据类型的长度。

ALTER TABLE table_columns MODIFY type varchar(200)