Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by PeterSkomoroch: http://wiki.apache.org/hadoop/Hive/LanguageManual/DML The comment on the change is: clarified that the table create statement drives the output format as well... ------------------------------------------------------------------------------ ===== Synopsis ===== * directory can be full URI. If scheme or authority are not specified, Hive will use the scheme and authority from hadoop configuration variable `fs.default.name` that specifies the Namenode URI. * if LOCAL keyword is used - then Hive will write data to the directory on the local file system. - * Data written to the filesystem is serialized as text with columns separated by ^A and rows separated by newlines. If any of the columns are not of primitive type - then those columns are serialized to JSON format. + * Data written to the filesystem is serialized as text with columns separated by ^A and rows separated by newlines. This default format can be changed by choosing a different format in the table CREATE statement (for example: FIELDS TERMINATED BY '\t'). If any of the columns are not of primitive type - then those columns are serialized to JSON format. ===== Notes ===== * Insert statements to directories, local directories and tables (or partitions) can all be used together within the same query.
