interview question hive partitioning and bucketing : <p>I am new to Hive and i recently had an interview in which i was asked below questions. can someone help with the right answer.</p>

<ol>
<li>While doing partioning what if data is missing from one column how will partitioning handle it?</li>
<li>Can you import log file using sqoop? I gave the answer NO as sqoop is used to import data from RDBMS tables to hadoop.</li>
<li>In the employee table if the value is null for any data can you still sqoop it?</li>
<li>Employee table is given with employee id, location, salary, department, whaat column will be used in partioning and bucketting? I think we can use department as partioning and employee id, location and salary can be used as bucketing, please confirm.</li>
</ol>
