Stata odbc query column labels from impala

[Jannic Cutura]

I am trying to access data from impala sql into Stata:

 
 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:

 
 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