Questions: 1.how to join manage table and external table 2.what is performance tuning and configuration tuning? and give real time example for this. 3.what is the difference between hive and hbase? 4.When we create a table we define ware or partition statements,what is the difference between these two?
3> HIVE HBASE ——————————————————————–***———————————————————————- 1.Hive is in short an analytical tool 1.HBase is a column-orienetd datastore. 2.It provides a SQL-like language, so it makes it fairly easy 2.It’s all about performance and is widely used as a back-end for to write batch/hadoop jobs. high throughput systems. 3.It does support basic indexes, but it doesn’t facilitate run-times 3.You can also write map-reduce jobs against HBase. anywhere close to real-time.