Member since
12-08-2016
36
Posts
2
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2428 | 01-04-2017 01:21 AM |
08-24-2018
08:09 PM
@Sagar Shimpi : will this process cleanup physical folders and dependencies automatically by running curl command or Ambari service deletion ? if not , do we need to delete manually ? thanks in advance.
... View more
03-28-2017
07:53 PM
Let me make it clear HDFS Level- we have only valid partitions (parition1,parition2) Table Level - we have both valid(parition1,partition2) and invalid partitions(partition3,partition4). I would like to drop only invalid partitions(partition3,partition4). -> Unable to drop by passing Url encoded characters & Timestamp. -> Created invalid partition at HDFS level, unable to drop. -> Issued MCSK REPAIR command , post success also unable to drop. Thanks
... View more
03-28-2017
07:39 PM
It is not working and notified to Hortonworks team. Soon I got the answer will post it here.
... View more
03-28-2017
07:07 PM
Adding to that , we are able to drop the partitions at HDFS level, but those invalid partitions were not dropped even after MCSK REPAIR TABLE command too.
... View more
03-16-2017
12:54 PM
Deepesh - it did not worked. Getting below error. With IF EXIST Error: Error while compiling statement: FAILED: ParseException line 1:75 mismatched input 'IF' expecting ( near 'PARTITION' in drop partition statement (state=42000,code=40000) Without IF EXIST - Error: Error while compiling statement: FAILED: SemanticException Unexpected unknown partitions for (load_s = 2017-02-22 12:21:39.0) (state=42000,code=40000)
... View more
03-15-2017
07:19 PM
Let me make it clear HDFS Level- we have only valid partitions (parition1,parition2) Table Level - we have both valid(parition1,partition2) and invalid partitions(partition3,partition4). I would like to drop only invalid partitions(partition3,partition4). -> Unable to drop by passing Url encoded characters & Timestamp. -> Created invalid partition at HDFS level, unable to drop. -> Issued MCSK REPAIR command , post success also unable to drop. ALTER TABLE tablename DROP PARTITION IF EXISTS (load_s='2017-02-22 12:21:39'); - did not worked. ALTER TABLE tablename DROP PARTITION (load_s='2017-02-22 12:21:39'); - did not worked. ALTER TABLE tablename DROP PARTITION (load_s='2017-02-22 12%3A21%3A39'); - did not worked.
... View more
Labels:
- Labels:
-
Apache Hadoop
-
Apache Hive
02-28-2017
06:19 PM
@peeyush Thanks for your help. Followed the same and issue been resolved.
... View more
02-23-2017
02:48 AM
Recently we had HDP 2.5.3 version upgrade, post validation steps we are checking Falcon job flows. we got a strange error stating -"cluster Entry vertex must exist" . did any one had the same and any fix ? Even after Falcon server restart is not solving the issue. I could see some one have raised Falcon Jira request too. https://issues.apache.org/jira/browse/FALCON-1955 any help , greatly appreciated.
... View more
Labels:
- Labels:
-
Apache Falcon
-
Apache Hadoop
-
Apache Oozie
01-19-2017
01:37 PM
Labels:
- Labels:
-
Apache Hadoop
01-09-2017
04:18 PM
Thank you @Kuldeep Kulkarni
... View more