Known Issues in DAS
This topic describes known issues and workarounds for using DAS in this release of Cloudera Runtime.
-
You may not see any data for a report for any new queries that you run. This can happen, especially for the last one day's report.
Workaround:- Shut down the DAS Event Processor.
- Run the following command from the Postgres server:
update das.report_scheduler_run_audit set status = 'FAILED' where status = 'READING';
- Start the DAS Event Processor.
- On clusters secured with Knox proxy only: You might not be able to save the changes to the JDBC URL in the DAS UI to change the server interface (HS2 or LLAP) on which you are running your queries.
- You may be unable to upload tables or get an error while browsing files to upload tables in DAS on a cluster secured using Knox proxy.
-
DAS does not parse semicolons (;) and double hyphens (--) in strings and comments.
For example, if you have a semicolon in query such as the following, the query might fail:
select * from properties where prop_value = "name1;name2";
If a semicolon is present in a comment, then execute the query after removing the semicolon from the comment, or removing the comment altogether. For example:select * from test; -- select * from test; select * from test; /* comment; comment */
Queries with double hyphens (--) might also fail. For example:select * from test where option = '--name';
- You might face UI issues on Google Chrome while using faceted search. We recommend you to use the latest version of Google Chrome (version 71.x or higher).
- You are unable to see databases or the query editor on the Compose page even after following the troubleshooting procedure. This can be caused due to incorrect hive service name in ZooKeeper.
- Visual Explain for the same query shows different graphs on the Compose page and the Query Details page.
- While running some queries, if you restart HSI, the query execution is stopped. However, DAS does not reflect this change and the queries appear to be in the same state forever.
- After a fresh installation, when there is no data and you try to access the Reports tab, it throws HTTP 404 Not Found Error.
- Join count does not get updated for tables with partitioned columns.