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

Phoenix issue-Distribution-IBM BigInsights- Hbase(1.1.1)-Phoenix 4.7

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      When I try to create a table with any columns having data type other than
      varchar(I tried double and unsigned double) throws below error.
      Error: ERROR 201 (22000): Illegal data. Expected length of at least 8
      bytes, but had 4 (state=22000,code=201)
      java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of
      at least 8 bytes, but had 4
      at
      org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:422)
      at
      org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
      at org.apache.phoenix.schema.KeyValueSchema.next(KeyValueSchema.java:211)
      at
      org.apache.phoenix.expression.ProjectedColumnExpression.evaluate(ProjectedColumnExpression.java:115)
      at
      org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
      at
      org.apache.phoenix.jdbc.PhoenixResultSet.getObject(PhoenixResultSet.java:524)
      at sqlline.Rows$Row.(Rows.java:157)
      at sqlline.BufferedRows.(BufferedRows.java:38)
      at sqlline.SqlLine.print(SqlLine.java:1650)
      at sqlline.Commands.execute(Commands.java:833)
      at sqlline.Commands.sql(Commands.java:732)
      at sqlline.SqlLine.dispatch(SqlLine.java:808)
      at sqlline.SqlLine.begin(SqlLine.java:681)
      at sqlline.SqlLine.start(SqlLine.java:398)
      at sqlline.SqlLine.main(SqlLine.java:292)
      Works fine if I use varchar as datatype for every column. Please help me
      with this issue?
      Thanks,
      Anupriya

      Attachments

        Activity

          People

            Unassigned Unassigned
            anupriya Anupriya
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: