Re: Problem Updating Stats

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

Re: Problem Updating Stats

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

Re: Problem Updating Stats

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

Re: Problem Updating Stats

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,

Re: Problem Updating Stats

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

Re: Problem Updating Stats

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

Re: Problem Updating Stats

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

Problem Updating Stats

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