[jira] [Created] (IMPALA-7313) LOAD DATA does not create partitions on-demand (inconsistent with INSERT)

["Todd Lipcon (JIRA)" <ji...@apache.org>]

Todd Lipcon created IMPALA-7313:
-----------------------------------

             Summary: LOAD DATA does not create partitions on-demand (inconsistent with INSERT)
                 Key: IMPALA-7313
                 URL: https://issues.apache.org/jira/browse/IMPALA-7313
             Project: IMPALA
          Issue Type: Improvement
          Components: Docs, Frontend
    Affects Versions: Impala 3.0
            Reporter: Todd Lipcon


I noticed this inconsistency while working on IMPALA-7311: if a table is partitioned, new partitions are created on-demand by statements like:

{code}
INSERT INTO t PARTITION (...) ...
{code}

However, the following SQL does _not_ create a partition on demand:

{code}
LOAD DATA INPATH '...path...' INTO TABLE t PARTITION (...);
{code}

Instead, it fails with "Partition spec does not exist: (...)"

This seems inconsistent and makes the LOAD DATA statement less useful. It seems this should at least be called out in the documentation for LOAD DATA if it's intentional, and perhaps fixed if it's not intentional (perhaps LOAD DATA predates automatic partition creation support?)



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

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org