I'm getting the following error when joining a table with its cloned copy.
select oldtable.dt from OLD_QTABLE as oldtable INNER JOIN NEW_QTABLE as
newtable ON oldtable.dt=newtable.dt group by oldtable.dt;
java.lang.IllegalArgumentException: Timestamp cannot be negative.
minStamp:-4239669727594509121, maxStamp:3190689910792567145
at org.apache.hadoop.hbase.io.TimeRange.<init>(TimeRange.java:76)
at
org.apache.phoenix.compile.ScanRanges.getAscTimeRange(ScanRanges.java:658)
at
org.apache.phoenix.compile.ScanRanges.getRowTimestampColumnRange(ScanRanges.java:629)
at org.apache.phoenix.compile.ScanRanges.create(ScanRanges.java:79)
at
org.apache.phoenix.compile.WhereOptimizer.pushKeyExpressionsToScan(WhereOptimizer.java:305)
at
org.apache.phoenix.compile.WhereOptimizer.pushKeyExpressionsToScan(WhereOptimizer.java:104)
at
org.apache.phoenix.compile.WhereOptimizer.getKeyExpressionCombination(WhereOptimizer.java:379)
at
org.apache.phoenix.compile.QueryCompiler.getKeyExpressionCombinations(QueryCompiler.java:463)
at
org.apache.phoenix.compile.QueryCompiler.compileJoinQuery(QueryCompiler.java:317)
at
org.apache.phoenix.compile.JoinCompiler.optimize(JoinCompiler.java:1163)
at
org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:197)
at
org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:160)
NEW_QTABLE is a copy of QTABLE. I created a snapshot of QTABLE and cloned
snapshot using:
disable 'QTABLE'
snapshot 'QTABLE', 'NEW_QTABLE'
clone_snapshot 'QTABLE_SNAPSHOT', 'NEW_QTABLE'
delete_snapshot 'QTABLE_SNAPSHOT'
enable 'QTABLE'
I then recreate the NEW_QTABLE in Phoenix using the same ddl with the new
table name.
/usr/hdp/current/phoenix-client/bin/sqlline.py zkhost:2181:/hbase-unsecure
0: jdbc:phoenix:zkhost:2181:/hbase-unsecur> CREATE TABLE IF NOT EXISTS
NEW_QTABLE (... etc...);
Note: I did not use the CurrentSCN parameter on connection.
Any ideas how to fix this?
Cheers,
Michael
