Re: Trafodion meta table region in hbase cannot be opened

2016-09-22 Thread
; > If you go into the hbase shell, and do the following: > > > > scan “TRAFODION._MD_.VERSIONS” > > > > What happens? If HBase is up and working correctly, and if nothing has been > corrupted, this should return 3 rows. > > > > Dave > > > > *Fr

Re: Trafodion meta table region in hbase cannot be opened

2016-09-21 Thread
rds, Qiao 乔彦克 <qya...@gmail.com>于2016年9月22日周四 上午11:07写道: > Hi, deal group, > Yesterday after I restarted the HBase regionservers(cause one is > down, I want to restart all the regionservers for load balance), there are > 7 Trafodion table regions cannot be ope

Re: trafodion query optimization

2016-09-19 Thread
ons. > > Could you please send us the output of the showstats command above, and > the showstats command below for all columns in the table? > > showstats for table TRAFODION.SEABASE.VISIT_FROM_HIVE2 on every column; > > Thanks --Qifan > > On Mon, Sep 19, 2016 at 3:15 AM, 乔彦克 <qya

Re: trafodion query optimization

2016-09-19 Thread
in performance: >> - use of aligned format (see above example) >> - careful choice of the primary key (bad idea to use a varchar with big >> max >> size) >> - It is good idea to use compression and encoding (see the most common >> options we use above) >> - you

trafodion query optimization

2016-09-12 Thread
Hi all, I executed the sum and count query on my table where the cluster has three nodes. I found that the sum query is not well parallel executed(not all the three nodes get high load when executing the sum query) and the cpu load is very high while the memory load is very low(the machines

Re: Load with log error rows gets Trafodion not work

2016-09-08 Thread
command below to confirm if > the > > version installed has the above fix. > > > > > > > > sqvers -u > > > > > > > > Can you also issue the following command to confirm if the Trafodion and > > hbase are started successfully. > > > > > >

can Trafodion store Chinese character

2016-09-07 Thread
Hi, all, I insert some lines with Chinese character into trafodion, but only get '???' where should be Chinese characters. Yesterday I want to load some data from Hive, this problem also emerged. The field ddl contains Chinese character is 'title varchar(100 bytes) CHARACTER SET UTF8 ,'.