phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject CQ as the key?
Date Mon, 29 Sep 2014 13:15:44 GMT
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

Mime
View raw message