Convert scientific notation string to number in Hive-CodePudding

Home > database > Convert scientific notation string to number in Hive

Convert scientific notation string to number in Hive

Time：11-26

I have a dirty table on Cloudera with a number string column. Some numbers are as-is in their 8-digit form while others are in scientific notation e.g. 91234567 vs 9.1234567E7. When numbers end in zero(es), there are fewer decimals e.g. 9.12E7 for 91200000. How do I convert all of them to their 8-digit representation?

I have tried the following, to no avail:

-- Remove 'E7' then convert the string to a decimal
,CASE WHEN m_number LIKE '


          
          
            Page link：https//www.codepudding.com/database/205770.html
          
          
               Prev:Unable to load the "PHP Email Form" Library
               Next:Change pixel order of a .tiff file from rgbrgb to rrbbgg (interleaved to non-interleaved)


  
    
      
        
          
             Tags：  
sql hadoop hive cloudera impala               
        
      
    
  
 
    
      
        
        	
            	Related
            
                       
        
      
    
  

  
    
      
        
           Links：  
          CodePudding

            
      
    
  


  About Us:          Contact Us      Terms of Service      
Privacy Policy
  Copyright © 2010-2023，Powered By CodePudding