I would like to write a table in sas to hadoop. How do I write. My current code...   proc sql; connect to hadoop (user=john password=xxxxx server="myhadoopmachine.public.com" port=10000 SCHEMA=hiveSchema subprotocol=hive2 dbmax_text=300 CFG="/opt/sas/myhadoopmachine/myhadoopmachine_core_hdfs_site.xml"); execute ( create table hivelib.mytable as select * from saslib.mytable ) by hadoop ;     results in error:   ERROR: Execute error: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 1:49 Table not found 'mytable'   The basic issue is that I can execute sql command on hive. The above expects the saslib.mytable to be on hadoop server under the schema saslib.mytable.  saslib.mytable is my sas lib with table name mylib.    How do I pass this information in the above proc sql to copy the sas data set to hadoop.   Thanks,   John       ... View more