Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-498

cast to varchar only returns one row

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 0.4.0
    • None
    • None

    Description

      Tried the patch for JIRA496, now the storage engine is able to read parquet files, but cast only returns one row.

      0: jdbc:drill:schema=dfs> select * from days;
      ----------------------+

      day week_day

      ----------------------+

      1 [B@2cef1cb4
      2 [B@6458478
      5 [B@3dfbe57f
      4 [B@649814a3
      3 [B@3c730ced
      6 [B@2555ba9c
      7 [B@1f4e6aea

      ----------------------+
      7 rows selected (1.829 seconds)
      0: jdbc:drill:schema=dfs> select `day`, cast(week_day as varchar(20)) from days;
      ----------------------+

      day EXPR$1

      ----------------------+

      1 Sunday
      2  
      5  
      4  
      3  
      6  
      7  

      ----------------------+

      Attachments

        Activity

          People

            sphillips Steven Phillips
            cchang@maprtech.com Chun Chang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: