phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Delete from table issue in phoenix-2.2.3
Date Mon, 24 Feb 2014 16:59:28 GMT
Do you hav

On Monday, February 24, 2014, Skanda <skanda.ganapathy@gmail.com> wrote:

> Sorry I get the below exception when I try to do a delete from table :
>
> Error: ERROR 504 (42703): Undefined column. columnName=K1
> (state=42703,code=504)
>
> Example table : create table "test"("k1" varchar,"k2" varchar,"d"."v1"
> unsigned_int,"d"."v2" varchar CONSTRAINT pk PRIMARY KEY("k1","k2"));
>
> Query : delete from "test" where "v2"='dummy';
>
>
> On Mon, Feb 24, 2014 at 6:12 PM, Skanda <skanda.ganapathy@gmail.com<javascript:_e(%7B%7D,'cvml','skanda.ganapathy@gmail.com');>
> > wrote:
>
>> Hi,
>>
>> The delete command doesn't work for tables and columns that are defined
>> to be in lower-case.
>>  I'm getting the following exception :
>>
>> Error: ERROR 1012 (42M03): Table undefined. tableName=test
>> (state=42M03,code=1012)
>>
>> The same works for tables and columns in upper-case.
>>
>> Example table : create table "test"(k1 varchar,k2 varchar,"d"."v1"
>> unsigned_int,"d"."v2" varchar CONSTRAINT pk PRIMARY KEY(k1,k2));
>>
>> Query : delete from "test" where "v2"='dummy';
>>
>> Regards,
>> Skanda
>>
>>
>>
>
>

Mime
View raw message