Drill is mainly a SQL query engine, and it has very limited support for DDL (only has CTAS for parquet files). As such, Drill does not have the ability to create index or unique constraint. However, if your underneath storage is a RDBMS, you could put the index / unique constraint in RDBMS, and use Drill to query RDBMS through JDBC plugin.
On Wed, Mar 30, 2016 at 7:23 AM, Wilburn, Scott <[email protected]> wrote: > All, > I didn't get any response on this question. Does anyone have a comment or > advice for me? I didn't see anywhere in the Drill online docs that explain > indexes or unique constraints. Did I miss something? > > Thanks, > Scott Wilburn > > > -----Original Message----- > From: Wilburn, Scott [mailto:[email protected]] > Sent: Friday, March 25, 2016 01:20 PM > To: [email protected] > Subject: [E] Drill indexes > > Hello, > Is there a way to index or create primary keys for fields in Drill? I'm > interested in indexing for performance and also for creating unique > constraints. If there is no way to create indexes, then is there another way > to generate a unique constraint? > > Thanks, > Scott Wilburn >
