Could you please support us with the problem described below?
We have HDP version 3.1
Arcadia version 5.0
Connection to Hive without arcengine
Dashboard on top of Hive managed table
We are trying to create Arcadia Dashboard on top of Hive managed table. It is possible without arcengine.
Unfortunately we have big problem with filters when we try to use custom field as a filter.
BUT the same custom field is shown fine on the table visual.
Steps to create our filter:
- Create dataset
- Go to dataset -> Fields
- Edit Fields
- Clone e.g. field contract_id
- Change display name to CopyContract_id
- Go to dasboard based on this dataset and edit it
- Go to Filters and click on dimension Copycontract_id to use it as a filter
- We have then the following error message:
Filter 5133 - Could not load data
error: (42000, 10004) Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 3:11 Invalid table alias or column reference \u0026#39;Copycontract_id\u0026#39;: (possible column names are: contract_id)
Data type of contract_id and Copycontract_id is String.
We don’t have such error message only for type timestamp - filter is working fine for timestamp type custom fields.
If we will change data type of Copycontract_id to timestamp we will be able to use it as a filter.