title: Query non-partitioned column on Entire Hive external Table
body: <p>I have hive external table (s3 files stored in parquet format) created with spark about 30 GB in size and with few hundreds of partitions. However I need to query the data on a non partition column (say SUPPLIER_ID) to see complete transaction history but not specific to a period or date (Partition columns). How can I ensure this query pattern where I am not sure which partition data belongs to on a Hive table?</p>