RE: HiveSQL with Python: Tables and Columns

[arcange]

You will get a better view of how tables are organized by pre-sorting data 😉

SELECT
    table_name, 
    column_name
FROM 
    INFORMATION_SCHEMA.COLUMNS
ORDER BY
    table_name, 
    ordinal_position

Another problem is programmatically limiting the number of rows you retrieve without including it in a loop could invalidate your script if the total number of rows returned becomes greater than your limit.

Comments

[geekgirl]

Thank you @arcange! I will try that.