Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Check if value is number

Hi All,

 

Is there any way to check value is number or text without installing anyother addin or user define function.

 

Many Thanks!.

Comments

  •  Is this at load time (for the copy command). Or is for data that is already in the db(maybe not !)?

  • In both cases..

    1) at the of data load - skip row if value is non numeric
    2) data available in table - In select statement maybe in where clause
  •  

     

    1) at the of data load - skip row if value is non numeric

     - i guess you need ot do it before you put data in.

     Use an ETL tool, or do it by hand in Bash 


    2) data available in table - In select statement maybe in where clause

    Use the projeciton_columns to identify the data type :

    Ex:

     

    select table_name,column_name,data_type from columns;

    What do you want to achive by doing this ? maybe there is a better way 

     

     

     

  • Basically I want to put a join in between two tables but the problem is the data type is not same in both tables Colums (which i want to use for join), one table column is integer and another table column is varchar or string format.

    Please suggest!.

    Thank!..

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.