想看看阿里音乐第二赛季的数据,却始终无法查看,总是报这个错误,请大家帮忙看看是什么问题。
Create table if not exists mars_tianchi_songs2 as select * from prj_tc_33929_8f5375972c78.mars_tianchi_songs;(我看资料上说大概就这样的语句就能够导入数据,但总是报错)
其中表prj_tc_33929_8f5375972c78.mars_tianchi_songs是从数据管理平台上找到的数据。
是不是导入数据思路有错,大家帮忙说一下第二赛季的数据如何访问。
报错如下:
正在提交...waitingwaiting2016-06-22 22:13:10 INFO Current task status:RUNNING2016-06-22 22:13:10 INFO Start execute shell on node e80h12367.et2.2016-06-22 22:13:10 INFO Current working dir /home/admin/alisatasknode/taskinfo/20160622/dide/22-13-04/zq8gshh8uu6rfm2at4q5mh102016-06-22 22:13:10 INFO Full Command ..2016-06-22 22:13:10 INFO -------------------------2016-06-22 22:13:10 INFO /opt/taobao/tbdpapp/odpswrapper/odpswrapper.py /home/admin/alisatasknode/taskinfo//20160622/dide/22-13-04/zq8gshh8uu6rfm2at4q5mh10//main.sql --skiphooks2016-06-22 22:13:10 INFO -------------------------2016-06-22 22:13:10 INFO List of passing environment ..2016-06-22 22:13:10 INFO -------------------------2016-06-22 22:13:10 INFO ODPS_SQL_RETRY=false:2016-06-22 22:13:10 INFO SKYNET_ARGS_ENABLE=true:2016-06-22 22:13:10 INFO SKYNET_SYSTEM_ENV=dev:2016-06-22 22:13:10 INFO SKYNET_GMTDATE=20160622:2016-06-22 22:13:10 INFO IS_NEW_SCHEDULE=true:2016-06-22 22:13:10 INFO SKYNET_PACKAGEID=prj_tc_42619_5d0d0247fb25:2016-06-22 22:13:10 INFO SKYNET_ONDUTY=241937165907232962:2016-06-22 22:13:10 INFO SKYNET_CONNECTION=***************:2016-06-22 22:13:10 INFO SKYNET_ARGS={}:2016-06-22 22:13:10 INFO SKYNET_PTYPE=10:2016-06-22 22:13:10 INFO ALISA_TASK_ID=T3_0005586101:2016-06-22 22:13:10 INFO ALISA_TASK_EXEC_TARGET=sys_default:2016-06-22 22:13:10 INFO ALISA_TASK_PRIORITY=2:2016-06-22 22:13:10 INFO --- Invoking Shell command line now ---2016-06-22 22:13:10 INFO =================================================================2016-06-22 22:13:10 config file is ok!!!2016-06-22 22:13:10 Env ODPS_SQL_RETRY skips SQL retry2016-06-22 22:13:10 sql:set SKYNET_ID=-;set SKYNET_BIZDATE=-;set SKYNET_PACKAGEID=prj_tc_42619_5d0d0247fb25;set SKYNET_CYCTIME=-;set SKYNET_TASKID=-;set SKYNET_SYSTEMID=-;set SKYNET_PRIORITY=-;set SKYNET_JOBID=-;set SKYNET_ONDUTY=241937165907232962;set SKYNET_TENANT_ID=-;set WRAPPER_SQLSEQ=1;set WRAPPER_RETRYNUM=1;set biz_id=-_-_-_-_1_prj_tc_42619_5d0d0247fb25_241937165907232962_-;Create table if not exists mars_tianchi_songs2 as select * from prj_tc_33929_8f5375972c78.mars_tianchi_songs;OKOKOKOKOKOKOKOKOKOKOKOKOK2016-06-22 22:13:12 start to get jobId:2016-06-22 22:13:12 get jobid:20160622141312463gnc21gqpID = 20160622141312463gnc21gqpLog view:
FAILED: ODPS-0130013:Authorization exception - Authorization Failed [4002], You doesn't exist in project prj_tc_33929_8f5375972c78. Context ID:356772f4-2ea7-4f8a-910d-539c3ffae643.2016-06-22 22:13:18 INFO =================================================================2016-06-22 22:13:18 INFO Exit code of the Shell command 1002016-06-22 22:13:18 INFO --- Invocation of Shell command completed ---2016-06-22 22:13:18 ERROR Shell run failed!2016-06-22 22:13:18 ERROR Current task status: ERROR2016-06-22 22:13:18 INFO Cost time is: 8.514s/home/admin/alisatasknode/taskinfo//20160622/dide/22-13-04/zq8gshh8uu6rfm2at4q5mh10/T3_0005586101.log-END-EOF
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。