RE: Related to INSERT QUERY in Hive

2012-01-17 Thread Krishnan Krishnamoorthy
Hi Aniket/Bhavesh, Actually load data inpath is used for appending file and the path refers to the HDFS path. We can use load data local inpath in case the input file to be loaded is not in HDFS but it is present in the local system. Both of these append the data. In case, you need to overwrit

FW: Hive_Datatypes_Complex

2012-01-16 Thread Krishnan Krishnamoorthy
Hi, I've been trying to find out how to create data files for input into tables having the following descriptions : * CREATE TABLE complex_array ( col1 ARRAY); * CREATE TABLE complex_map ( col2 MAP); * CREATE TABLE complex_struct ( col3 STRUCT); I'd be really gra