I Find phoenix write is too slow can you help me? Thanks ? My post is here https://community.hortonworks.com/questions/76862/phoenix-write-is-too-slow.html ... View more

I use hdinsight, HDinsight version is i change some parameter in hbase-site.xml <property> <name>hbase.client.scanner.timeout.period</name> <value>9200000</value></property> <property> <name>hbase.rpc.timeout</name> <value>9200000</value></property> <property> <name>hbase.regionserver.lease.period</name> <value>9200000</value></property> <property> <name>phoenix.query.timeoutMs</name> <value>9200000</value></property> but i Encounter problems this table is 700G My cluster is 5 regionserer(8 core,14G) Where is the problem? ... View more

Thank you ! I find some error in hbase regioneserver log ,TERMINALDATA ’s index state is disable(x) so now hbase now can rebuild but faild 2016-11-17 06:01:47,352 WARN org.apache.phoenix.coprocessor.MetaDataRegionObserver: ScheduledBuildIndexTask failed! org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=TERMINALDATA at org.apache.phoenix.schema.PMetaDataImpl.getTable(PMetaDataImpl.java:241) at org.apache.phoenix.util.PhoenixRuntime.getTable(PhoenixRuntime.java:316) at org.apache.phoenix.coprocessor.MetaDataRegionObserver$BuildIndexScheduleTask.run(MetaDataRegionObserver.java:228) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) so i check table schema so I Want to know is there relation with table schema when i create table i din't creat table schema my create table sql is create table if not exists "TerminalData" ( "RowKey" varchar primary Key, "ID" varchar, "CtrlAddress" varchar, "CanSN" varchar, "CtrlVersion" varchar, "Voltage" varchar, "A_Voltage" varchar, "B_Voltage" varchar, "C_Voltage" varchar, "Current" varchar, "A_current" varchar, "B_current" varchar, "C_current" varchar, "RatedPower" varchar, "ReactivePower" varchar, "TotalPowerFactor" varchar, "ZeroLineCurrent" varchar, "VoltageUR" varchar, "CurrentUR" varchar, "DirectVoltage" varchar, "DirectCurrent" varchar, "UpTime" varchar, "FaultState" varchar, "ActivePower" varchar, "ChageBillId" varchar, "DataKey" varchar ) default_column_family = 'd' ... View more

I Hear through tools can find which region is used in regionserver ?Did you know about tool? what's name about tool? I think My region server show 3000-4000 region (8G Heap), May be only part region is common used other 3000 region 3000*2M =6G this Impossible ... View more

My HDP Version HDP-2.4.2.0-258, I diont change config about phoenix default paramater but I didn't find my index is rebuilded automatically because this index'state is always rebuild(b) why? Thanks ! ... View more

I USE THIS commond ALTER INDEX IF EXISTS SysActionLog_idx ON "SysActionLog" REBUILD; but error the error is timeout. so i change phoeinx query sql timeout but index current state is i execute rebuild command but the other error occured,I cant drip index ,because my cluster is not strong ,cant create index success this table is 800G. ... View more

Thanks. I Find my table's index state is x ,How I can change this index state? rebuild it ? ... View more

Thanks. I Find my table's index state is x ,How I can change this index state? rebuild it ? ... View more

my primary key is "RowKey" IS NOT IN WHERE CLAUSE ... View more