Hello, I'd like to write some HQL to iterate on the columns of a table. When I show columns in <tablename> the result shows rows returned and what looks like a column called field. Then it seems like I should be able to use a subquery to write a select statment for each of these result rows but I just haven't been able to make it work. Then how can I achieve this?
An example of how I would use this would be to get Nulls for each column returned from the show tables command.
