I have two questions regarding loading tables which are defined as RCFile, Sequencfile etc.
Q1. 1. Suppose a table is defined as STORED AS RCFILE or SEQUENCEFILE, how do we load this table. If source data file is in CSV format, do we have to load that file in some temp table and then load the target RCFile table from this temp table using INSERT OVERWRITE.... If this is true then does it mean we can only have managed table which could be defined as RCFile,SEQUENCEFile as we can not load external table using INSERT statement. 2. How can we store the data in external table which is defined as RCFile. Do we have to convert the source data file in RCFile format first using some tool. Q2. When we use DESCRIBE FORMATTED <TableName> it shows COMPRESSED = NO. What does this mean, Even for compressed data in a table it shows NO. Thanks, Kuldeep
