HDInsight specifying the output directory

Basic syntax

' /example/demo/ ' Select  from table;

Can format output

' /test_select/output ' ' \ t ' Select  from table;

You can also export to remote HDFS

' Wasb://[email protected]/test-select-output/01 '  Select  from table;

Remember: query results are placed locally. can use

Row format delimited

To format the result of the output:

If the output directory is the remote address of the HDFS path: Format output is not allowed

Note: export to local can be set by the row format delimiter, export to HDFs is not set delimiter ;

It is also important to note that the data export statement is not a permission to create a directory. If the specified output directory does not exist, it is not created automatically: There will be no output results:

Remember to ensure that the directory exists before exporting.

HDInsight Specify output directory