Member since
07-22-2019
2
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2127 | 07-24-2019 06:32 AM |
07-24-2019
06:32 AM
Thank you for the answer, I found how to fix the problem, I cannot drop the table because there are a table in MySQL that defines what's locked or not. The table is "HIVE_LOCKS", from hive database, I just deleted the data correlated to my table and I was able to drop it. Thanks
... View more
07-22-2019
08:11 PM
Hello all, I'm a little new in Haddop world, so, please forgive me any kind of questions that I'm doing. In first place, I installed a 7 node cluster in my environment, all of them has DataNode (I know now that's the worst scenario, but, it's already installed and no time to fix it). In this morning, a simple process that need to drop a partitioned table in Hive isn't working anymore, there was no modification on cluster. The simple command is "drop table ods.tims_declaracao;". Well, I think that I got the problem worse, I removed the directory "/apps/hive/warehouse/ods.db/tims_declaracao". I thought that I would drop the table, well, I realize that it was not. The table still hanging in drop the metadata. Can some good soul help me to find out what's the problem? Regards.
... View more
Labels:
- Labels:
-
Apache Hive