Member since
04-14-2017
11
Posts
3
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
5573 | 01-10-2023 09:25 AM |
01-10-2023
09:25 AM
2 Kudos
Hello Prakodi, We do not have a specific script to export all the DDL's of the table for a schema in hive, however, what you are looking for could be solved with the command SHOW CREATE TABLE <HIVE_Table_name>; and you will have to put this in the shell script to retrieve all the table names first and then run show create table for all the tables of the schema. I did a search online and found an external blog article doing the same. Please refer that https://dwgeek.com/export-hive-table-ddl-syntax-and-shell-script-example.html/ Let us know if you have any questions. - Varun
... View more
09-05-2019
12:26 PM
Hello @neron , Based on the error messages, it looks like you have not flushed the iptables which is requirement for setting up CDSW. You can find more information here: https://www.cloudera.com/documentation/data-science-workbench/latest/topics/cdsw_requirements_supported_versions.html#networking_security_req Flush IPTables, Stop Firewalld, Reset weave, Restart host 1) Stop all the instances CM > CDSW > Instances > All > Stop 2) SSH to the master node and clear all iptable rules. iptables -P INPUT ACCEPT iptables -P FORWARD ACCEPT iptables -P OUTPUT ACCEPT iptables -t nat -F iptables -t mangle -F iptables -F iptables -X 3) Stop firewalld service and disable it at boot time. systemctl stop firewalld systemctl disable firewalld 4) From CM selectively start only the Docker instance (this is important to carry out next step) 5) Submit the following command to reset weave: # /opt/cloudera/parcels/CDSW/cni/bin/weave reset --force 6) Stop Docker role which we started in step 4. 7). Restart Host # init 6 😎 Start Docker and Master roles to ensure if all POD's comes up fine. If yes, start the Application role. I hope this will be helpful.
... View more