I am trying to access data from impala sql into Stata:
Code:
 
 clear all #delimit; odbc load, exec(" SELECT column_name data_base_name.table_name ") dsn("<my dsn>") user("") password(""); #delimit cr
The query works just fine, but the labels are empty. Is there any way to get those into stata?

I created comments the following way:
Code:
 
 ALTER TABLE  data_base_name.table_name CHANGE column_name column_name string comment 'test comment';
So when I import to Stata the variable name column_name should have the label "test comment". Is this possible? Or any other way (other than comment I mean)?


Crosposted on Stack Overflow