Re: Select * gets 0 rows from index table

2020-03-30 Thread Reid Chan
dexTool to rebuild the index? No. -- Best regards, R.C From: swaroopa kadam Sent: 31 March 2020 00:38 To: user@phoenix.apache.org Subject: Re: Select * gets 0 rows from index table Hey Reid, Some questions: What is the empty c

Re: Select * gets 0 rows from index table

2020-03-30 Thread swaroopa kadam
gt; >> * Did you use Phoenix to create the data+index tables and to populate > the data in those tables? > > Yes. > > > > -- > > Best regards, > R.C > > > > ____ > From: Josh Elser > Sent: 30 March 2020 23:42

Re: Select * gets 0 rows from index table

2020-03-30 Thread Reid Chan
ndex tables and to populate the >> data in those tables? Yes. -- Best regards, R.C From: Josh Elser Sent: 30 March 2020 23:42 To: user@phoenix.apache.org Subject: Re: Select * gets 0 rows from index table Hey Reid!

Re: Select * gets 0 rows from index table

2020-03-30 Thread Josh Elser
Hey Reid! Can you clarify a couple of things? * What version of Phoenix? * Did you `select * from index_table` verbatim? Most of the time, when you have an index table, you'd be interacting with the data table which (behind the scenes) goes to the index table. * * Caveat about covered columns

Select * gets 0 rows from index table

2020-03-30 Thread Reid Chan
Hi team, I encountered a problem that select * from index_table limit x got 0 rows, but underlying hbase has data (observed it from hbase shell > scan) and any queries went to index table would get 0 rows as well. In the meantime the server had the following error message: "index.GlobalIndexCh