You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by ashish tapdiya <as...@gmail.com> on 2016/11/03 23:19:23 UTC

Error loading data in transactional table

Hi,

I have tried loading data in a transactional table using psql.py and
mapreduce loader and both result in errors

1. psql.py error:
ERROR util.CSVCommonsLoader: Error upserting record

2. map-reduce based loader

16/11/03 22:45:01 INFO mapreduce.Job: Task Id :
attempt_1478189793665_0001_m_000000_1, Status : FAILED
Error: java.lang.RuntimeException: java.lang.NullPointerException
        at
org.apache.phoenix.mapreduce.FormatToBytesWritableMapper.map(FormatToBytesWritableMapper.java:202)
        at
org.apache.phoenix.mapreduce.FormatToBytesWritableMapper.map(FormatToBytesWritableMapper.java:74)
        at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:145)
        at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:784)
        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341)
        at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:415)
        at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1692)
        at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
Caused by: java.lang.NullPointerException
        at
org.apache.tephra.TransactionContext.start(TransactionContext.java:91)
        at
org.apache.phoenix.execute.MutationState.startTransaction(MutationState.java:422)
        at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:339)
        at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:332)
        at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
        at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:331)
        at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:250)
        at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:172)
        at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:177)
        at
org.apache.phoenix.util.csv.CsvUpsertExecutor.execute(CsvUpsertExecutor.java:86)
        at
org.apache.phoenix.util.csv.CsvUpsertExecutor.execute(CsvUpsertExecutor.java:46)
        at
org.apache.phoenix.util.UpsertExecutor.execute(UpsertExecutor.java:133)
        at
org.apache.phoenix.mapreduce.FormatToBytesWritableMapper.map(FormatToBytesWritableMapper.java:171)

Thanks,
Ashish