Two external tables point to same hdfs location

[#1]

Hi

Is it possible to have two external tables point to the same hdfs location?

Thanks

Shannon

[#2]

Yes. It may cause issues depending on how you are using it when ingestion data into it. What are you trying to do? I wonder if a Hive view would be better then a separate table.

[#3 · Accepted solution]

Thanks i was doing something for short term, worked.