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.

[ganeshreddy]

Hi Anusha,

Use upper(<fieldname>) for upper case. And use Capitalize(<field name>/<string>/<caption>/Headings)

Ex : Upper(Name)  output will be         -  ANUSHA

       Capitalize(MY name Is AnuSha) out put will be   -  My Name Is Anusha

Regards,

Ganesh

[ashwanin]

I don't think that upper () function will help you in this case.

You have to do mapping. follow below thread ,if this help you.

How to rename a field in qlikview

[Anonymous]

Hi Jagan,

without renaming the fields while loading automatically fields names has to be changed to uppercase is it possible .( currently my data in sql server in this db all the column and table names are upper case after we moved the data to hadoop , the table names and column names are changed to lower case lowers)

[Anonymous]

Hi Mohith,

I am confused little bit. will you please explain briefly. Please it is my urgent requirement.

[jagan]

Hi,

I think it is not possible, you need to do it manually.

Regards,

Jagan.

[Anonymous]

Hi All,

Thanks For Your Response , but here our requirement is some thing different ,now we got the data and after loading the data we came to know that all fields/columns are in Lower case , how to change all the Column names into upper case at a time instead of writing Upper() function for each and every Column , is there any way to convert all the column names into Upper case...

Please respond if you any idea to resolve this...

Thanks in advance...

Regards

Anusha

[Anonymous]

Hi,

for all the columns to write uppercase it is risky I think .we use qualifier *,for changing all the field names in a table like that we have any function to convert all the fields to uppercase in a table

[SergeyMak]

Hi Anusha,

Probably stupid idea, but..

Try to copy the script into MS Word,

select All (Ctrl+A) and

press Shift+F3.

It will convert full script to uppercase.

Then copy it back to Load script and try to reload.

Regards,

Sergey

[SergeyMak]

and if you need to convert only fieldnames and they are formatted like:

filed1               AS Field1,

thefieldname2  AS Field2

you can try to select them in MS Word with mouse and Alt pressed. In this case you will be able to select not line by line but vertically and then Shit+F3

Regards,

Sergey

[Anonymous]

Hi Sergey,

Already my data in uppercase but I am loading my data using hadoop(Big data) it converts all the fields and table names to lower how to resolve automatically while loading