How Can An Query for Getting Metadata Cost 9G memory?
We use Sqoop to pull the data from Vertica. Sqoop generates a query with condition (1=0) to get the field type information and the query does not need to return any records. However, the query needs 9G memory allocations, just as the second query Sqoop fired for returning the records. We think this is wrong... could anyone help on this? Do we have any trick to let the trivial query (with condition 1=0) to use minimum memory?