Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day
In Compose (Gen2) version 2021.8.0.465, when using Recreate Views on a project with a lot of tables, we are getting a webex timeout. I believe the views are recreated in the background, but would like a confirmation.
Any way to set the timeout to a bigger value?
Hi @Abrie_M
Can you please enable the "Generate DDL scripts but do not run them" option and recreate the views?
I've attached a screenshot for the same.
Please keep me updated with the results.
Regards,
Adam
Hi Adam
Thank you for the suggestion. I've extracted the DDL and will run it in Hive/Hue.
Will have to find the best way, eventually, because some of our projects have more than 500 tables.
I'll let you know what the outcome is.
Regards
Abrie
Hi Nanda
I was able to run the DDL and create the views in Hue. I'll work on this with our Cloudera admins and log a ticket if we can get more detailed information.
Thanx
Abrie
Hi @Abrie_M
Can you please enable the "Generate DDL scripts but do not run them" option and recreate the views?
I've attached a screenshot for the same.
Please keep me updated with the results.
Regards,
Adam
Hi Adam
Thank you for the suggestion. I've extracted the DDL and will run it in Hive/Hue.
Will have to find the best way, eventually, because some of our projects have more than 500 tables.
I'll let you know what the outcome is.
Regards
Abrie
Thank you @Abrie_M , I will be waiting for your reply on this.
However, in case you'll face the same error, or a new error/issue, then please, raise a case to the support team provided with the deployment package, server logs, and full description of the issue (including a screenshot of the error) and I will investigate it further.
Please keep me updated, and do not hesitate to contact me for any doubts you might have.
Regards,
Adam
Hello @Abrie_M
I just wanted to follow up with @Adam_Herman comments to see if you are still having the Webex timeout error when recreating the views. If so, please open a support case and the team should be able to find the root cause and fix it.
Let us know.
Thanks,
Nanda
Hi Nanda
I was able to run the DDL and create the views in Hue. I'll work on this with our Cloudera admins and log a ticket if we can get more detailed information.
Thanx
Abrie
Thank you for the update @Abrie_M - Yes please,
Please notice, that you might be facing issues/errors which we have already addressed in our latest patches of Compose.
Therefore, please keep me updated on any issues, raise a ticket for the same, and I will gladly assist - That would be the best way to investigate your case.
Many thanks!
Have a great day ahead 🙂
Regards,
Adam