Hi
I have a Questions about external tables
Suppose I have this kind of directory structure in hdfs.
/user/Mydata/Data1/part-000
/user/Mydata/Data1/part-001
/user/Mydata/Data1/part-002
...
1- I have created the external table and point to directory
"/user/Mydata/Data1" of hdfs to load data. Hive
Viraj,
1. No
2. Yes, smaller table needs to fit in jvm memory (typically more than
1GB for small table is too large).
See slide 7 and after in this preso for different join strategies that
can help in case the tables are bucketed and sorted.
http://www.slideshare.net/zshao/hive-user-meeting
