Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1319

After casting INT to CHAR, there may be a lot of trailing junk chars

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • Impala 2.0
    • Impala 2.0
    • None
    • None

    Description

      Example:

      [localhost.localdomain:21000] > select cast(999 as char(128));
      Query: select cast(999 as char(128))
      Prettytable cannot resolve string columns values that have  embedded tabs. Reverting to tab delimited text output
      999&K
      'K
      LM
      LN	OP	OQ
      LR	#S
      #T
      UV	#W
      #X	#Y
      #Z	#[
      #\
      L]
      L^
      #_
      #`
      La
      #b
      #c
      Ld
      Le
      
      Fetched 1 row(s) in 0.02s
      
      
      [localhost.localdomain:21000] > select length(cast(999 as char(128)));
      Query: select length(cast(999 as char(128)))
      +--------------------------------+
      | length(cast(999 as char(128))) |
      +--------------------------------+
      | 128                            |
      +--------------------------------+
      Fetched 1 row(s) in 0.02s
      

      Attachments

        Activity

          People

            victor.bittorf_impala_fcb6 Victor Bittorf
            caseyc casey
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: