List all partitions from Hive Table

Cheat Code
> show partitions database_name.table_name

I was asked to list all partitions for the transaction hive table because somehow the number are not complete, so I ran the above cheat code to check all date partitions on my transaction tables.
Simple right!?

Once we found the missing partitions, we can just simple reload it from our raw dataset in data lake

Photo by Engin Akyurt from Pexels

Published by Feivel

We love to travel!

13 thoughts on “List all partitions from Hive Table

  1. It is appropriate time to make some plans for the future
    and it is time to be happy. I have read this post and if I could
    I want to suggest you some interesting things or advice. Perhaps you can write next articles referring to this article.
    I desire to read more things about it!

    Like

  2. Long time reader, first time commenter — so, thought I’d drop a comment..
    — and at the same time ask for a favor.

    Your wordpress site is very simplistic – hope you don’t mind me asking what
    theme you’re using? (and don’t mind if I steal it?
    :P)

    I just launched my small businesses site –also built in wordpress like yours– but the theme slows (!) the site down quite a bit.

    In case you have a minute, you can find it by searching for “royal cbd” on Google (would appreciate any feedback)

    Keep up the good work– and take care of yourself during the coronavirus scare!

    ~Justin

    Like

    1. We are using “Twenty Seventeen” theme and small surgery on it to remove some of the EXTRA freebies that came with it to keep the page simple and clean.
      Thanks for supporting us cheating!

      Like

  3. I don’t even know how I ended up here, however I assumed this post used to be
    great. I don’t know who you might be but certainly you are
    going to a famous blogger should you aren’t already.
    Cheers!

    Like

  4. Hi, i believe that i noticed you visited my website so
    i got here to return the favor?.I’m trying to find things to improve my site!I guess its good
    enough to make use of a few of your ideas!!

    Like

  5. It’s a pity you don’t have a donate button! I’d certainly donate
    to this superb blog! I guess for now i’ll settle for bookmarking and adding your RSS feed to
    my Google account. I look forward to new updates and will talk about this site with my Facebook group.
    Chat soon!

    Like

  6. It is truly a nice and useful piece of info.
    I’m happy that you simply shared this helpful information with us.
    Please keep us informed like this. Thanks for sharing.

    Like

  7. I have learn several excellent stuff here. Certainly value
    bookmarking for revisiting. I wonder how a lot attempt you put to create this kind of
    great informative website.

    Like

  8. I have read so many articles or reviews on the topic of the blogger lovers however this article is
    really a fastidious piece of writing, keep it up.

    Like

Leave a reply to Pamela Cancel reply

Design a site like this with WordPress.com
Get started