Member since
09-15-2020
245
Posts
19
Kudos Received
9
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 940 | 12-16-2025 12:15 AM | |
| 3921 | 11-08-2024 08:45 PM | |
| 1486 | 03-28-2024 06:38 AM | |
| 2179 | 02-22-2024 02:53 AM | |
| 1155 | 02-21-2024 06:55 AM |
02-21-2024
06:55 AM
1 Kudo
Hi @wert_1311 Thank you for reaching out to Cloudera Community, Cloudera provide an observability tool called "Observability" which help you monitor jobs within a cluster. You can refer below documentation on how this tool can be configured and used. https://docs.cloudera.com/observability/cloud/overview/topics/obs-understanding-observ.html
... View more
02-21-2024
05:54 AM
Hi @echodot your table seems to be transactional, that is why it is not getting altered. Please create a non-tractional table and then perform your task
... View more
02-20-2024
09:20 AM
Hi @Shivakuk Please refer below doc, you can use the Revoke statements in sentry to restrict the access on a database https://docs.cloudera.com/documentation/enterprise/6/latest/topics/sg_hive_sql.html#revoke_privilege_statement Let us know if this helps
... View more
02-20-2024
09:14 AM
@echodot Try to execute the queries below and then run your query. # alter table ATABLE set tblproperties('impala.disable.recursive.listing'='true'); # refresh ATABLE; # check if your query works or not
... View more
02-16-2024
05:18 AM
Hi @echodot As the source table is not in parquet format, try ing below command to create and load the data CREATE TABLE jmaster.hivetesttable AS SELECT * FROM JMASTER.ATABLE STORED AS PARQUET;
... View more
02-15-2024
08:05 AM
1 Kudo
Hi @Hae You may refer below document to generate authentication token and access HUE API https://docs.cloudera.com/data-warehouse/cloud/managing-warehouses/topics/dw-jwt-generate-token-later.html https://docs.gethue.com/developer/api/rest/ Let us know if this helps!
... View more
02-15-2024
07:09 AM
Hi @skasireddy , you may use below property in the workflow.xml oozie.launcher.mapred.job.priority=VERY_HIGH Let us know if this helps.
... View more
02-15-2024
06:44 AM
Hi @lbourgeois Can you try creating table using CREATE EXTERNAL TABLE command. Let us know if this works
... View more
02-15-2024
01:46 AM
1 Kudo
HI @echodot Did you try to execute refresh command on table --> jmaster.hivetesttable. Does same error persist, after executing refresh command? If the problem still persist, then execute below steps for confirming that the file is valid. --> Download the partition or file in local disk. --> Execute below command to validate the file parquet-tools meta <full_path_to_file_name_in_the_local_disk>
... View more
02-13-2024
11:19 AM
1 Kudo
Hi @ipson Please check table schema and verify if ('external.table.purge'='true') property is set using S This property controls how DROP TABLE and ALTER TABLE works. In case it is not present, then add this property for the required table( issue the ALTER TABLE stmt twice) ALTER TABLE t SET TBLPROPERTIES ('external.table.purge'='true');
ALTER TABLE t SET TBLPROPERTIES ('external.table.purge'='true'); The first invocation sets the property in HMS. The second one persists it to Iceberg metadata. Let me know if this helps.
... View more