Hive 表在 Tableau 中不可见 [英] Hive tables Not Visible in Tableau

问题描述

我在配置单元的默认数据库中创建了一个表 ztest7.我可以使用直线查询它.在 tableau 中，我可以使用自定义 sql 进行查询.

I have created a table, ztest7 in the default database in my hive. I am able to query it using beeline. In tableau, I can query it using a custom sql.

但是，当我搜索它时，该表格并未显示.

我在这里遗漏了什么吗?

Am I missing something here?

Tableau Desktop Version = v10.1.1  
Hive = v2.0.1  
Spark = v2.1.0

最好的问候

推荐答案

我有同样的问题，从 Tableau Desktop 10 (mac) 到 Hive (2.1.1) 通过 Spark SQL 2.1(在 centos 7 服务器上)这是我从 Tableau 支持那里得到的:

I have the same issue with Tableau Desktop 10 (mac) to Hive (2.1.1) via Spark SQL 2.1 (on centos 7 server) This is what I got from Tableau Support:

在 Tableau Desktop 中，无需连接即可连接到 Spark SQL定义默认架构当前未内置到产品中.

In Tableau Desktop, the ability to connect to Spark SQL without a defining a default schema is not currently built into the product.

作为初步步骤，要定义默认架构，请配置 Spark使用 SchemaRDD 或 DataFrame 的 SQL hivemetastore.这必须是在 Hive Metastore 中为 Tableau Desktop 定义，以便能够访问它.Spark SQL 无法查询纯无模式 Spark RDD因为缺少模式.RDD 可以转换为SchemaRDDs，它有额外的模式元数据作为 Spark SQL提供对 SchemaRDD 的访问.创建 SchemaRDD 时，它只是在本地命名空间或上下文中可用，并且不可用于通过 ODBC 和 Spark Thrift 访问 Spark 的外部服务服务器.为了让 Tableau 能够访问，SchemaRDD 需要是在本地以外的目录中注册语境;Hive Metastore 是目前唯一受支持的服务.

As a preliminary step, to define a default schema, configure the Spark SQL hivemetastore to utilize a SchemaRDD or DataFrame. This must be defined in the Hive Metastore for Tableau Desktop to be able to access it. Pure schema-less Spark RDD's can not be queried by Spark SQL because of the lack of a schema. RDDs can be converted into SchemaRDDs, which have additional schema metadata as Spark SQL provides access to SchemaRDDs. When a SchemaRDD is created, it is only available in the local namespace or context, and is unavailable to external services accessing Spark through ODBC and the Spark Thrift Server. For Tableau to have access, the SchemaRDD needs to be registered in a catalog that is available outside of just the local context; the Hive Metastore is currently the only supported service.

我不知道如何检查/实现这一点.

I don't know how to check/implement this.

PS:我会将此作为评论发布，因为我是 Stack Overflow 的新手，因此不允许我这样做.

PS: I'd have posted this as a comment because I am not allowed to as I am new to Stack Overflow.

这篇关于Hive 表在 Tableau 中不可见的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！