Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1078

Unable to run pig script with Phoenix in a secure HBase cluster

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 4.3.1, 4.4.0
    • None

    Description

      I am running the HBase0.94.15 and latest phoenix 3.1 nightly build. I have to use pig on phoenix views. This is a secure HBase cluster. When i run the job i get following error:
      ERROR org.apache.hadoop.hbase.io.HbaseObjectWritable - Error in readFields
      java.lang.NegativeArraySizeException: -1
      at org.apache.hadoop.hbase.util.Bytes.readByteArray(Bytes.java:175)
      at org.apache.phoenix.schema.PColumnImpl.readFields(PColumnImpl.java:157)
      at org.apache.phoenix.schema.PTableImpl.readFields(PTableImpl.java:721)
      at org.apache.phoenix.coprocessor.MetaDataProtocol$MetaDataMutationResult.readFields(MetaDataProtocol.java:161)
      at org.apache.hadoop.hbase.io.HbaseObjectWritable.readObject(HbaseObjectWritable.java:692)
      at org.apache.hadoop.hbase.io.HbaseObjectWritable.readObject(HbaseObjectWritable.java:596)
      at org.apache.hadoop.hbase.client.coprocessor.ExecResult.readFields(ExecResult.java:83)
      at org.apache.hadoop.hbase.io.HbaseObjectWritable.readObject(HbaseObjectWritable.java:692)
      at org.apache.hadoop.hbase.io.HbaseObjectWritable.readFields(HbaseObjectWritable.java:333)
      at org.apache.hadoop.hbase.ipc.SecureClient$SecureConnection.receiveResponse(SecureClient.java:383)
      at org.apache.hadoop.hbase.ipc.HBaseClient$Connection.run(HBaseClient.java:588)

      Here is my pig script:
      register /tmp/phoenix-3.1-jars/phoenix-core-3.1.0-SNAPSHOT.jar;
      register /tmp/phoenix-3.1-jars/phoenix-pig-3.1.0-SNAPSHOT.jar;
      A = load 'hbase://query/SELECT * from test_table' using org.apache.phoenix.pig.PhoenixHBaseLoader('ZK');
      grpd = GROUP A BY UNSIGNED_DATE_COLUMN;
      cnt = FOREACH grpd GENERATE group AS UNSIGNED_DATE_COLUMN,COUNT(A);
      DUMP cnt;

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jeffreyz Jeffrey Zhong
            anilgupta84 Anil Gupta
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment