Hive
  1. Hive
  2. HIVE-14

selecting fields from a complex object column in transform clause is throwing a Parse Error.

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Critical Critical
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query Processor
    • Labels:
      None

      Description

      For a thrift table whose columns are complex objects the following query throws up an error

      from ( from cdx select transform(cdx.a.b) as tx using 'mapper' cluster by tx ) mo insert into output select tx;

      the error thrown on the second . of expresion 'cdx.a.b'.

        Activity

        Prasad Chakka created issue -
        Owen O'Malley made changes -
        Field Original Value New Value
        Key HADOOP-4496 HIVE-14
        Project Hadoop Core [ 12310240 ] Hadoop Hive [ 12310843 ]
        Component/s contrib/hive [ 12312455 ]
        Assignee Ashish Thusoo [ athusoo ]
        Affects Version/s 0.19.0 [ 12313211 ]
        Ashish Thusoo made changes -
        Component/s Query Processor [ 12312586 ]
        Hide
        Ashish Thusoo added a comment -

        I think this has also been addressed. Will verify and then close out.

        Show
        Ashish Thusoo added a comment - I think this has also been addressed. Will verify and then close out.
        Ashish Thusoo made changes -
        Priority Major [ 3 ] Critical [ 2 ]
        Hide
        Ashish Thusoo added a comment -

        Prasad,

        can you verify if this works and close out...

        Thanks,
        Ashish

        Show
        Ashish Thusoo added a comment - Prasad, can you verify if this works and close out... Thanks, Ashish
        Hide
        JunHo Cho added a comment -

        I think that this query's syntax is wrong. "as tx" must follows "using 'mapper'". so this query should is changed like
        "from (from cdx select transform(cdx.a.b) using 'mapper' as tx cluster by tx) mo insert into output select tx;". also hive should be patched about "insert into" - HIVE-2207.

        Show
        JunHo Cho added a comment - I think that this query's syntax is wrong. "as tx" must follows "using 'mapper'". so this query should is changed like "from (from cdx select transform(cdx.a.b) using 'mapper' as tx cluster by tx) mo insert into output select tx;". also hive should be patched about "insert into" - HIVE-2207 .

          People

          • Assignee:
            Unassigned
            Reporter:
            Prasad Chakka
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development