phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yuan Yifan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-5166) DELETE didn't work on phoenix
Date Tue, 26 Feb 2019 07:41:10 GMT

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

Yuan Yifan commented on PHOENIX-5166:
-------------------------------------

There's no index or view on this table, just use F_VEHICLE_ID and F_GPS_TIME as pk, and let F_GPS_TIME
as row timestamp , the describe of the table is:

!image-2019-02-26-15-36-47-364.png!

May I know where is the code for Phoenix to delete the data? So I can try to debug it.

 

Besides, the SQL I used to create this table is:
{code:sql}
CREATE TABLE T_LOCATION (
  F_VEHICLE_ID BIGINT NOT NULL,
  F_GPS_TIME TIME NOT NULL,

  F_LATITUDE BIGINT,
  F_LONGITUDE BIGINT,
  F_HIGH INTEGER,
  F_IS_REAL_LOCATION BOOLEAN,
  F_SPEED INTEGER,
  F_DSPEED INTEGER,
  F_DIRECTION SMALLINT,
  F_OIL_LEVEL INTEGER,
  F_MILEAGE BIGINT,
  F_RECV_TIME TIME,
  F_ACC_STATUS BOOLEAN,
  F_ISPASSUP BOOLEAN,
  F_AREASN VARCHAR(6),
  F_GPSENCRYPT BOOLEAN,
  F_GPSSTATE BIGINT,
  F_EXPAND_STATE BIGINT,
  F_DEV_BATTERY INTEGER,
  F_MCC INTEGER,
  F_MNC INTEGER,
  F_LAC INTEGER,
  F_CELLID INTEGER,
  F_PATTERN INTEGER,
  F_MODE INTEGER,
  F_REAL_STATE INTEGER,
  F_ROAD_ID BINARY(12),
  F_ROAD_LEVEL INTEGER,
  F_ROAD_NAME VARCHAR,
  F_ROAD_SPEED_LIMIT INTEGER,
  F_ROAD_TRUCK_SPEED_LIMIT INTEGER,
  F_GEO VARCHAR,
  F_CAN_VERSION TINYINT,
  F_ALARM_COUNT INTEGER,

  CONSTRAINT T_LOCATION_pk PRIMARY KEY (F_VEHICLE_ID, F_GPS_TIME ROW_TIMESTAMP)
);
{code}

> DELETE didn't work on phoenix
> -----------------------------
>
>                 Key: PHOENIX-5166
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5166
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.14.1
>         Environment: Apache HBase 1.4
> Phoenix 4.14.1
>            Reporter: Yuan Yifan
>            Priority: Major
>             Fix For: 4.15.0
>
>         Attachments: image-2019-02-26-13-56-44-201.png, image-2019-02-26-14-34-50-580.png,
image-2019-02-26-15-35-53-229.png, image-2019-02-26-15-36-08-649.png, image-2019-02-26-15-36-47-364.png
>
>
> I executed an SQL that delete some data in table T_LOCATION, the data decreased.
> But there're still 256 rows of data which I can't delete them however I run DELETE repeatedly.
> !image-2019-02-26-13-56-44-201.png!
>  
> I'm preparing to fix it but I don't know where the code should I debug, is there any
document of the structure/design of Phoenix?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message