Can we have both normal tables and external tables in one database with primary key - foreign key relation ship between them? The external table is backed by blob storage and the file format is parquet. If we can have relation what if some one directly access the parquet file from blob and update it?
Asked
Active
Viewed 451 times
1
Joy George Kunjikkuru
- 1,495
- 13
- 27
-
Doesn't seems we can as external table are not supporting primary keys. – Joy George Kunjikkuru Aug 13 '17 at 19:53