Ankit,
I did not see any problems when connecting with the phoenix sqlline client. So,
below is the what you asked for. I hope that you can give us insight into
fixing this.
hbase(main):005:0> describe 'SYSTEM.STATS'
Table SYSTEM.STATS is ENABLED
ok , or you could have drop SYSTEM.STATS table from sql client at
CURRENT_SCN=7 and reconnect the client. If client doesn't see this table ,
it will create it automatically.
On Thu, Mar 17, 2016 at 3:14 AM, Benjamin Kim wrote:
> I got it to work by uninstalling Phoenix and reinstalling it again.
I got it to work by uninstalling Phoenix and reinstalling it again. I had to
wipe clean all components.
Thanks,
Ben
> On Mar 16, 2016, at 10:47 AM, Ankit Singhal wrote:
>
> It seems from the attached logs that you have upgraded phoenix to 4.7 version
> and now you are using old client to conn
It seems from the attached logs that you have upgraded phoenix to 4.7
version and now you are using old client to connect with it.
"Update statistics" command and guideposts will not work with old client
after upgradation to 4.7, you need to use the new client for such
operations.
On Wed, Mar 16,
Ankit,
We tried a 4.7 client upgrade to use the phoenix spark client as an experiment;
then, rolled back to the sanctioned CDH 5.5 version of 4.5. I had no idea that
someone did an "update stats” during that period, and I didn’t know that there
would be a fundamental change as this. Do you know
Sorry Ben, I may not be clear in first comment but I need you to describe
SYSTEM.STATS in some sql client so that I can see the columns present.
And also please scan 'SYSTEM.CATALOG' ,{RAW=>true} in hbase shell and
attach a output here.
On Wed, Mar 16, 2016 at 8:55 PM, Benjamin Kim wrote:
> Anki
Yes it seems to.
Did you get any error related to SYSTEM.STATS when the client is connected
first time ?
can you please describe your system.stats table and paste the output here.
On Wed, Mar 16, 2016 at 3:24 AM, Benjamin Kim wrote:
> When trying to run update status on an existing table in hba
When trying to run update status on an existing table in hbase, I get error:
Update stats:
UPDATE STATISTICS "ops_csv" ALL
error:
ERROR 504 (42703): Undefined column. columnName=REGION_NAME
Looks like the meta data information is messed up, ie. there is no column with
name REGION_NAME in this tabl