Presto not able query Hive partition external table

[SivaSamrajS]

I have created the External table on hive from hadoop path with year and month partitions.
I have connected the hive with presto. I am able to query the data in hive, but the same table is not returning the data with presto(returning 0 rows).
Presto: 0.213
presto:retaildemov2> select * from customer; customer_id | account_num | lname | fname | mi | address1 | address2 | address3 | address4 | city | state_province | postal_code | country | customer_region_id | phone1 | phone2 | birthdate | marital_sta -------------+-------------+-------+-------+----+----------+----------+----------+----------+------+----------------+-------------+---------+--------------------+--------+--------+-----------+------------ (0 rows)

num_cars_owned | integer | | fullname | varchar | | event_ts | timestamp | | year | varchar | partition key | month | varchar | partition key |

[findepi]

When you create external table, you need to define all the partitions.
You can do this in Hive, by running msck repair table <table-name>;

[shlomialfasi]

Can the msck repair command run from Presto?

[SivaSamrajS]

Yes thanks. It did worked.

…

On Fri 7 Dec, 2018, 1:03 PM shlomialfasi ***@***.*** wrote: Can the msck repair command run from Presto? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#12025 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AqlcRO_G00Vo-rPlj9bbGJn7l9LQLS41ks5u2hnEgaJpZM4ZGbUE> .

[nezihyigitbasi]

Can the msck repair command run from Presto?

No, it's a hive command.

[prabakarankrishnan]

I also facing same problem. MSCK repair I did. I am able to query in Hive. But still presto not able to access...

[yuzhu]

i have noticed that after msck repair, i needed to run a select query in hive before presto can pick up the change and show results for select queries.. no idea why though..

[friendofasquid]

Hello from 2021.

At some point, looks like Presto has added system.sync_partition_metadata which should remove the need to run msck repair in Hive / Spark / Athena.