[jira] [Commented] (PHOENIX-5603) Phoenix add sybmol 0x00 to first in key

["Josh Elser (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-5603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16991761#comment-16991761 ] 

Josh Elser commented on PHOENIX-5603:
-------------------------------------

{quote}If data load without phoenix
{quote}
Further, if you intend to query data via Phoenix, you should be writing the data via Phoenix API. Otherwise, you are wholly responsible to know all Phoenix internals and ensure that they are manually updated.

> Phoenix add sybmol 0x00 to first in key
> ---------------------------------------
>
>                 Key: PHOENIX-5603
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5603
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 5.0.0
>         Environment: HDP 3.0 
> hbase 2.0.2.3.1.0.0-78
>            Reporter: Rustam Iksanov
>            Priority: Major
>         Attachments: keyWObyte.jpg, keyWbyte.jpg
>
>
> Phoenix add symbol `0X00` to rowkey in the salted table. If data load without phoenix, where aren't this byte.
> Create table with next script:
> ```CREATE TABLE TKT ("ROWKEY" varchar PRIMARY KEY,
> CREATED bigint);```
>  
> Write data always from spark connector, for example:
> ```df.write.format("org.apache.phoenix.spark").mode("overwrite").option("zkUrl", "zkServAdrs:2181").option("table", "TKT").save()```
>  
> And 2 scan from hbase shell. One table with salt, second similar table without salt.
>  
> Links to similar problem([https://stackoverflow.com/questions/47809243/phoenix-salted-table-rowkey-issue-with-hbase])



--
This message was sent by Atlassian Jira
(v8.3.4#803005)