how to convert the Coloumns and table names into upper case....?

[Anonymous]

Hi Team ,

I have an issue Currently we are sourcing data from Oracle (CDW ) and all the column names are in the upper case , we have to switch over to Hadoop  as our source soon , and all the data has been scooped from CDW to Hadoop but in that process all the column names are converted to Lower case by Hive/ Hadoop.

How to convert the column names and table names into upper case...?

Please help us we are unable to covert those into upper case...

Thanks in Advance..

Regards

Anusha.

[PrashantSangle]

Hi,

Use Upper() in script and for column names in you can use alise name

try like'

Upper(fieldName) as FIELDNAME

Regards

[ravindraa]

HI Anusha,

   Using "Upper" keyword we can change the values lower case to uppercase.

Ex:

load

upper(Country) as Countrt

from DB_table;

[jagan]

Hi Anusha,

Check this link for easier process for renaming

How to Rename Fields

For renmaing fields using the Mapping table.

Regards,

Jagan.

[nagarjuna_kotha]

Hi Jagan,

We can solve this problem using>>> Upper() and Renaming

Ex :

Table:

Load

Upper(Emp) as EMP,

Upper(Region) as REGION

From.....

[jagan]

Hi,

Upper() will convert values in a column to upper case not the Column names.

Regards,

Jagan.

[er_mohit]

Hi Anusha,

Go to this link Field names turned in to uppercase automatically

hope it helps

Regards

Mohit

[Anonymous]

Hi Anusha,

Try in this way:

Use Upper() in script for columns wich you want to convert into upper case

try like this

Upper(fieldName) as FIELDNAME

[#9]

Hi,

If u want to convert values into upper case use upper() or else if you want fieldname is upper just make it manual

Load Upper(field1) as FIELD1,

        Upper(field2) as FIELD2;

sql select field1,field2

from table;

[#10]

you can use upper() both in script and in labels for columns you need to rename