Hi Thank you for the reply...... I want to preserve the column names........ We recently moved everything from sql server into HIVE and in sas we have over 150 datasets for explorer.... These now dont work in sas explorer as when the tables are registed the format of the columns loose their capitals......this would result us having to rewrite all the tables as the cannot be read in sas explorer. We would need SAS/ACCESS to over come this but we only have sas 9.4 and no sas/access..... ... View more

I have setup the odbc to the hive environment. And it works......I actually have 2 setup one using Microsoft hive odbc and simba hive odbc as I thought I might overcome the issue with the latter driver.     libname and register shown in screen shots......       problem lies here in the following screenshot............. when I look at the tables registered from hive I see and can access them but the table columns are all small letters.....   But this is actually defined in hive as  CREATE EXTERNAL TABLE IF NOT EXISTS D_SRC_SYSTEMS_T ( `Src System Key`    string, Src_System_Nm    varchar    (50), Lets_Load_Batch_ID    varchar    (50), Lets_Load_Date    timestamp, Lets_Load_Update_Batch_ID    varchar    (50), Lets_Load_Update_Date    timestamp )   So when the table comes across it looses the capitals of each word................how can I preserve this when I bring the tables across..... I have tried enabled and disable case sensitive names in dbms dialog box shown in register screenshot ......but to no avail and i have also tried adding the command in the advanced section of both simba and microsoft obdc connections  LCaseSspKeyName = 0 again to no avail..............       ... View more