Member since
11-01-2019
135
Posts
3
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1519 | 03-23-2023 03:30 PM | |
1710 | 02-01-2023 12:44 PM |
03-23-2023
03:30 PM
1 Kudo
Hi @dearvenkat , Sorry I was thinking that you just want to change the value, but if you are using RENAME PARTITION sql command it will depend on which type of table you have If it's EXTERNAL the data in HDFS will remain in the same old directory. If your table is MANAGED it should change the directory name to the new one. Please refer to this article: https://community.cloudera.com/t5/Support-Questions/Partition-rename-in-Hive-HDFS-path/td-p/193283 Apache Hive SQL Reference: https://cwiki.apache.org/confluence/display/hive/languagemanual+ddl#LanguageManualDDL-RenamePartition
... View more
03-23-2023
09:22 AM
1 Kudo
Hi @dearvenkat , The old data will not be affected by this change. The column you have chosen to be partition of the table is not changing, what is changing is the internal value from N to Y, So it will create a new partition and the old data will remain on the partition activeFlag=N. It is the same if you have a partition by date, every day you will have a new partition and the other days remains on the past partitions. Hope that helps.
... View more
02-01-2023
12:54 PM
Hi @hades_63146 , If you are creating a Managed table in Hive via Spark, you need to use HiveWarehouseConnector. https://docs.cloudera.com/cdp-private-cloud-base/7.1.3/integrating-hive-and-bi/topics/hive_hivewarehouseconnector_for_handling_apache_spark_data.html If you are already using HWC, and it's failing, please share the code here and we can try to check what is missing. Good Luck.
... View more
02-01-2023
12:44 PM
1 Kudo
Hi @RobVi , Please try to follow the below steps from our article. https://my.cloudera.com/knowledge/ERROR-quotFAILED-SemanticException?id=340510 Let us know if works. Good Luck.
... View more
01-23-2023
02:40 PM
Hi @fabio_bd_araujo , We recommend you to download the latest Cloudera JDBC Driver here: https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-21.html Then in your DBeaver connection settings, go to Edit Driver Settings button and then to tab Libraries. There you will see the current jar, which is the default Apache Driver. Remove and then add the downloaded Cloudera jar. You should be able to connect using your usual string connection. Ps: You don't need to add log4j libraries. Cloudera Driver already have a logging option. Check the documentation here (page 27): https://docs.cloudera.com/documentation/other/connectors/hive-jdbc/2-6-21/Cloudera-JDBC-Connector-for-Apache-Hive-Install-Guide.pdf Good luck!
... View more
08-18-2022
01:10 PM
Hi @Teradata GTS , Are you looking for this property? tez.queue.name https://community.cloudera.com/t5/Support-Questions/tez-queue-name-vs-hive-server2-tez-default-queues-in/td-p/136345
... View more