Skip to content

While SQL Statement Contains lateral view explode JSQLParser throw an exception #239

Closed
@ABRUZI

Description

@ABRUZI

Hi there

My SQL statement like this

    select 
      order_id, 
      comment_label_id2, 
      create_time, 
      score, 
      remark 
    FROM 
      (
        select 
          score, 
          remark, 
          create_time, 
          order_id, 
          comment_label_id 
        from 
          bi_ods.t_scd_order_comment 
        where 
          create_time >= '2016-03-01' 
          AND create_time < '2016-03-02'
      ) as t lateral view explode(
        split(comment_label_id, ',')
      ) e as comment_label_id2

lateral view explode is supported by mysql and hiveql

Thank you

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions