Re: Creating SQL skin on Hbase table

2016-12-25 Thread Gunnar Tapper
Have you looked at trafodion.apache.org, which uses HBase as its native storage engine? On Sun, Dec 25, 2016 at 4:28 AM, Chetan Khatri wrote: > If I would like to read Incremental data from HBase , How Phoenix can help > me ? > > On Fri, Dec 23, 2016 at 2:20 AM,

Re: Creating SQL skin on Hbase table

2016-12-25 Thread Chetan Khatri
If I would like to read Incremental data from HBase , How Phoenix can help me ? On Fri, Dec 23, 2016 at 2:20 AM, Mich Talebzadeh wrote: > Hi, > > I have used Phoenix to create SQL views on top of Hbase table and also > created covering engines. The issue I have

Re: Creating SQL skin on Hbase table

2016-12-24 Thread Josh Elser
Yes, the expectation is that when using the Phoenix secondary-indexing feature, you also must use Phoenix to maintain the accuracy of the indices with the data table. However, even without secondary-indexing, why would you not use Phoenix APIs to update? If there are deficiencies in the

Creating SQL skin on Hbase table

2016-12-22 Thread Mich Talebzadeh
Hi, I have used Phoenix to create SQL views on top of Hbase table and also created covering engines. The issue I have noticed is that all ingestion has to go through Phoenix otherwise Phoenix indexes will not be updated. Another alternative has been to try Hive EXTERNAL tables on top of Hbase