CQ as the key?

[Jean-Marc Spaggiari]

Hi,

Can I have a column qualifier part of a key?

Doing this I define columns based on the RowKey:

create view "asset_metadata" (

   L unsigned_long not null,

   A unsigned_long not null,

   R bigint not null,

   "s".W unsigned_long,

   "s".P bigint,

   "s".N varchar,

   "s".E varchar,

   "s".S unsigned_long,

   "s".M unsigned_long,

   "s".T unsigned_int,

   CONSTRAINT pk primary key (L,A,R)
   );

But I would like to also have one key field as a CQ.

something like:

create view "asset_metadata" (

   L unsigned_long not null,

   A unsigned_long not null,

   R bigint not null,

   "s".W unsigned_long,

   "s".P bigint,

   "s".N varchar,

   "s".E varchar,

   "s".S unsigned_long,

   "s".M unsigned_long,

   "s".T unsigned_int,

   CONSTRAINT pk primary key (L,A,R,S:W)
   );

Is that doable? Is there a specific syntax for that?

Thanks,

JM