Hi...I am not able to get the difference between managed & external table.   I know the difference comes when dropping the table. I don't understand what you mean by the data and metadata is deleted in internal and only metadata is deleted in external tables. Can anyone please explain me, how to check it in backend. ... View more

Hello Everyone,   Why is PIG called a data flow language?   Thank you. ... View more

Hi Team,   Is there any variation in datatype & command for the different version of Hive?   As I am unable to use VARCHAR(64), for Hadoop 2.0 CDH 4.3.0.   Thanks.. ... View more

Hi All,   I am using cloudera 4.3.0. (System Config:-iIntel i3 Processor with 8GB RAM)Trying to create a Partitioning in Hive. Below is the detail:-   CREATE TABLE partitioned_user( firstname VARCHAR(64), lastname VARCHAR(64), address STRING, city VARCHAR(64), post STRING, phone1 VARCHAR(64), phone2 STRING, email STRING, web STRING ) PARTITIONED BY (country VARCHAR(64), state VARCHAR(64)) STORED AS SEQUENCEFILE;   But getting error as "FAILED: ParseException line 2:10 cannot recognize input near 'VARCHAR' '(' '64' in column type".   Can anyone please assist.   Thank You. ... View more