Hive
  1. Hive
  2. HIVE-6833

when output hive table query to HDFS file,users should have a separator of their own choice

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 0.11.0
    • Fix Version/s: None
    • Component/s: CLI
    • Labels:
      None
    • Environment:

      java version "1.6.0_24"
      OpenJDK Runtime Environment (IcedTea6 1.11.11.90) (rhel-1.62.1.11.11.90.el6_4-x86_64)
      OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)

      Description

      HIVE-3682 allows user to store output of Hive query to a local file along with delimiters and separators of their choice.
      e.g. insert overwrite local directory '/users/home/XYZ' row format delimited FIELDS TERMINATED BY ',' SELECT * from table_name;

      Storing query output with default separator(\001) to HDFS is possible.
      e.g. insert overwrite directory '/user/xYZ/security' SELECT * from table_name;

      But user can not store output of Hive query to a HDFS directory with delimiters and separators of their choice.
      e.g. insert overwrite directory '/user/xYZ/security' row format delimited FIELDS TERMINATED BY ',' SELECT * from table_name; (Gives ERROR)

        Issue Links

          Activity

          Hide
          Xuefu Zhang added a comment -

          Closed as duplicate of HIVE-5672.

          Show
          Xuefu Zhang added a comment - Closed as duplicate of HIVE-5672 .
          Hide
          Xuefu Zhang added a comment -

          This seems to be another dupe for HIVE-5672, which is already duped by HIVE-6410.

          Show
          Xuefu Zhang added a comment - This seems to be another dupe for HIVE-5672 , which is already duped by HIVE-6410 .

            People

            • Assignee:
              Unassigned
              Reporter:
              sourabh potnis
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development