In Hive or BigSQL, where your data is being put on HDFS through some means other than INSERTs, and your table has partitions, you will need to do some extra work to recognize the data.

First, after creating the table (or doing an initial load), you need to run a MSCK query. This will cause Hive/BigSQL to scan for and recognize any partitions that it is unaware of, and only needs to be done once:

MSCK REPAIR TABLE schemaName.tableName;

Next, any time you add a new partition outside of Hive/BigSQL, you will need to run an ALTER query to have Hive/BigSQL recognize and add it:

ALTER TABLE schemaName.tableName ADD PARTITION IF NOT EXISTS (col1='val1', col2='val2');

For BigSQL, you will also want to run an ANALYZE:

ANALYZE TABLE schemaName.tableName COMPUTE STATISTICS FOR ALL COLUMNS TABLESAMPLE SYSTEM (10);