Github user mygood commented on the issue:
https://github.com/apache/phoenix/pull/311
trace on not data into trace table
I use apache-phoenix-4.13.1-HBase-1.1-bin and hbase-1.1.6 and hadoop-2.7.1
cp $PHOENIX_HOME/phoenix-4.13.1-HBase-1.1-server.jar $HBASE_HOME/lib
cp $PHOENIX_HOME/bin/hadoop-metrics2-hbase.properties $HBASE_HOME/conf
cp $PHOENIX_HOME/bin/hadoop-metrics2-phoenix.properties $HBASE_HOME/conf
add hbase-sit.xml
<property>
<name>phoenix.trace.frequency</name>
<value>always</value>
</property>
<property>
<name>phoenix.trace.statsTableName</name>
<value>SYSTEM.TRACING_STATS</value>
</property>
<property>
<name>phoenix.trace.frequency</name>
<value>true</value>
</property>
run sqlline.py
create SYSTEM.TRACING_STATS
CREATE TABLE SYSTEM.TRACING_STATS (
trace_id BIGINT NOT NULL,
parent_id BIGINT NOT NULL,
span_id BIGINT NOT NULL,
description VARCHAR,
start_time BIGINT,
end_time BIGINT,
hostname VARCHAR,
tags.count SMALLINT,
annotations.count SMALLINT,
CONSTRAINT pk PRIMARY KEY (trace_id, parent_id, span_id)
)
0: jdbc:phoenix:localhost:2181:/hbase> trace on;
-----------------------
trace_id
-----------------------
-7450651397611882467
-----------------------
1 row selected (0.001 seconds)
0: jdbc:phoenix:localhost:2181:/hbase> create table t(a bigint not null
PRIMARY key,b bigint);
No rows affected (2.523 seconds)
0: jdbc:phoenix:localhost:2181:/hbase> !ta
------------------------------------------------------------------------------------------------------------+
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS TYPE_NAME
SELF_REFERENCING_COL_NAME REF_GENERATIO
------------------------------------------------------------------------------------------------------------+
SYSTEM CATALOG SYSTEM TABLE
SYSTEM FUNCTION SYSTEM TABLE
SYSTEM SEQUENCE SYSTEM TABLE
SYSTEM STATS SYSTEM TABLE
SYSTEM TRACING_STATS SYSTEM TABLE
T TABLE
------------------------------------------------------------------------------------------------------------+
0: jdbc:phoenix:localhost:2181:/hbase> upsert into t(a,b) values(1,1);
1 row affected (0.046 seconds)
0: jdbc:phoenix:localhost:2181:/hbase> select * from SYSTEM.TRACING_STATS
where trace_id=-7450651397611882467;
----------------------------------------------------------------------------------
TRACE_ID PARENT_ID SPAN_ID DESCRIPTION START_TIME END_TIME
HOSTNAME COUNT COUNT
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
No rows selected (0.09 seconds)
0: jdbc:phoenix:localhost:2181:/hbase> select * from SYSTEM.TRACING_STATS;
----------------------------------------------------------------------------------
TRACE_ID PARENT_ID SPAN_ID DESCRIPTION START_TIME END_TIME
HOSTNAME COUNT COUNT
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
No rows selected (0.09 seconds)
@MrSandmanRUS @joshelser
---
