救命,hive中使用insert into 不能插入数据,别的语句都行,求解(着急)

先简单叙述,最近有个项目需要使用hive,目前我的数据在一个map中,我使用jdbc连接hive,连接没有问题,创建表什么的也正常,但是一执行insert into 语句,就会卡住,就是一直转圈,不报错,然后我强行终止后会出现一张临时表,临时表中有我要插入的数据,但是并没有插入我指定的那张表,而且连接关闭重新连接后,临时表就消失了,救救我吧, 是在搞不定hive这个
我的问题类似于这个博主说的http://www.aboutyun.com/thread-20833-1-1.html

但是我不仅这样,我是一执行insert,还会卡主,不往下执行,我用idea的datasource也是这样,必须手动停止,然后就会出现临时表

hive的地址是公司给的地址

请问怎么办,拜托了各位学大数据的大神,已经折磨我一周了

图片说明

图片说明

2个回答

你有abc这张表吗,我看你的图片好像没有

u011856283
你好杰米 有的,在最上面,滚轮滚下去了
一年多之前 回复

解决了,不管是idea的工具还是用java的jdbc都插不进去,后来同事给弄了下,也不知道弄了啥,弄了下服务器那边,我这啥也没改就能插进去了,我也不知道怎么回事,虽然能插进去了,但是非常慢,最后还是选择了load方式,放弃insert into

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
在MySQL中,为什么不能使用insert语句连续插入数据?
有下列程序:rn$sql = "INSERT INTO `user_list` (`group_id`,`user_id`) VALUES(1,1)";rnmysql_query($sql, $db);rn$sql = "INSERT INTO `user_list` (`group_id`,`user_id`) VALUES(1,1)";rnmysql_query($sql, $db);rn可以正常插入数据。rn但是稍修改一下:rn$sql = "INSERT INTO `user_list` (`group_id`,`user_id`) VALUES(1,1);"."INSERT INTO `user_list` (`group_id`,`user_id`) VALUES(1,1);";rnmysql_query($sql, $db);rn却不能插入数据了!为什么?请大家帮忙看一下。
insert into 语句问题,着急!
程序利用insert into插入一个sql语句,详细情况如下:rninsert into rss_zzdz(username,celue) values ('xxx','select * from T_NewsSource where NewsSource_sTitle like '%geography%' and NewsSource_From like '%美国%' and NewsSource_NewsMainSubject ='数学物理'')rnrn系统错误提示如下:rnMicrosoft OLE DB Provider for ODBC Drivers 错误 '80040e14' rn[Microsoft][ODBC SQL Server Driver][SQL Server]在此上下文中不允许使用 'geography'。此处只允许使用常量、表达式或变量。不允许使用列名。rnrn请问怎么处理,是不是转义符的问题,请指教!
存储过程insert不能插入数据?
SET QUOTED_IDENTIFIER OFF rnGOrnSET ANSI_NULLS OFF rnGOrnrnrnrnrnrnALTER PROCEDURE [setFlagx]rn(rn@sscode varchar(10),rn@ssdate varchar(20),rn@o float,rn@c float,rn@h float,rn@l float,rn@vol int,rn@amount float,rn@ssFlag varchar(1)rn)rnASrndeclare @dataOr tinyintrnselect @dataOr=数据有否 from 数据完成指示 where 代码=@sscode and 日期=@ssdate rn--BEGIN TRAN AddOrder rnif @dataOr=1 --㩳取数据不存在,返回rnUPDATE [数据完成指示]rn SET [代码] = @sscode,rn [日期] = @ssdate,rn [开盘] = @o,rn [收盘] = @c,rn [最高] = @h,rn [最低] = @l,rn [成交量] = @vol,rn [成交额] = @amount rnWHERE rn ( [代码] = @sscode ANDrn [日期] = @ssdate ANDrn [数据有否]= 1)rnelse if @dataor=null rnINSERT INTO [数据完成指示] ( [代码], [日期], [数据有否], [开盘], [收盘], [最高], [最低], [成交量], [成交额]) rnVALUES ( @sscode, convert(datetime,@ssdate), convert(tinyint,@ssflag), @o, @c, @h, @l, @vol, @amount)rnif @@trancount>0 rncommit tran rn--BEGIN TRAN AddOrder rnrnrnrnGOrnSET QUOTED_IDENTIFIER OFF rnGOrnSET ANSI_NULLS ON rnGOrnrn 俺没弄过存储过程,也不想涉及太深,应付一下就行。大家见笑了rnselect @dataOr=数据有否 from 数据完成指示 where 代码=@sscode and 日期=@ssdate rn执行完这句后,@@trancount=1rnrn我就乱加了一句 if @@trancount>0 rncommit tran rnrninsert就可以插入数据,没有就不行,我想知道为什么,请朋友给说一说,谢谢。rn
一个的oracle小问题!insert into语句不能插入数据
我安装的是oracle8.1.6 ,新建了一个用户tablecht/tablecht ,我在 SQL PLUS里面用insert into 语句往表里插入一条数据,提示说已建一行,但是当我退出SQL PLUS 在重新进入的时候,上次插入的数据就没了。我用2个用户试过:tablecht/tabllecht system/manager 请问是什么原因???rn是不是权限的问题啊?rn请高手指教!!!
SQL语句插入数据insert
本系列视频从MySQL数据库基础到应用为大家全面讲述了MySQL数据库的安装、管理工具、字符集、数据库操作、运算符、函数、视图、触发器等相关日常操作使用!
insert语句在XP下不能使用
我写了一条INSERT语句,在有的xp版本下面不能正常 使用,而在2000和98下均可以正常使用。后台数据库为sql server,odbc连接。
Mybatis使用insert插入数据
mybatis使用insert方法插入mysql数据库,正常执行,在数据库中却没有显示
使用Python构造hive insert语句
mysql可以使用nevicat导出insert语句用于数据构造,但是hive无法直接导出insert语句。我们可以先打印在hive命令行,然后使用脚本拼装成insert语句,进行数据构造。 手动copy到python脚本进行sql语句构造: def transformString(s): list_s = s.split('\t') print(len(list_s)) ...
求插入数据(insert语句)的解决方法
我想将teacher中数据导入userinfo中,其中userinfo表typed字段(teacher中没有)需自己赋值,typed=4 rnINSERT INTO userinforn (USERNAME, PASSWORD, NUM, REALNAME, DEPART)rnSELECT NUM, NUM , NUM , TEACHERNAME, DEPARTrn FROM TEACHERrn怎么办?本人初学者,各位老大帮帮忙!
使用mybatis的insert语句插入数据的时候,获取插入数据的主键id
useGeneratedKeys="true" keyColumn="org_id" keyProperty="orgId"> 在mybatis的insert标签里面,添加3个属性值 useGeneratedKeys="true":获取主键并赋值 keyColumn="org_id":表中的字段 keyProperty="orgId":po类中的字段 3个属性值添加之
使用INSERT语句向ACCESS中插入数据时,遇到语法错误
我有一个ACCESS的表,其中包括一个 时间/日期 型字段 date (短日期)rnrnADOCommand1->CommandText="INSERT INTO table(date) values('2002-11-2')";rnADOCommand1->Execute();rnrn执行以后,会报错:INSERT INTO语句的语法错误
insert 插入数据
语法格式: insert into 表名称[(字段名称1,字段名称2……)]values[(值1,值2,……)];标准语法:对于没有数据的列就不写进字段列表;简略语法:如果插入时没有明确的写出字段,则没有值得字段用null来代替;两种写法比较:推荐使用标准写法,不推荐使用简略写法。简略写法再添加表字段的时候容易出问题。
hive插入数据
新建表 create table lintest(name string,id string) 添加新列 alter table lintest add columns(plus int) 向表中插入数据 insert overwrite table lintest select uuid,deviceid,'1',count(deviceid) as num from kuaiya.
insert into插入数据
insert into 表名称 values(值1,值2,...) 可以指定所要插入数据的列: INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....) 遇到了个自己都想不到的错误, 我一定是没睡醒
Hive之插入数据
Hive之插入数据 使用SQL语句创建一个表,如下: create table(id int,name string,addr string) t_1; 新建一个文件test01.txt。并往其中写入数据: vi test01.txt 1 gaoyuliang handong 2 houzi beijing 3 baozi handong 4 qit...
oracle 使用with insert插入数据的问题
今天有个写存储过程的朋友问我一个with a  as  。。。。insert 的存储过程为什么总是报错:ORA-00928: 缺失 SELECT 关键字 最后发现with后面只能直接跟select 不能跟insert,修改后解决问题 修改前: with  a as(SELECT T.StationId,U.Id AS UserId  FROM Sys_Station_In
Hive插入数据
1、创建完表之后,就可以插入数据了,在hive中,一般使用LOAD DATA插入数据,数据来源一般为两种,一种是从本地文件系统,第二种是从hadoop文件系统。基本语法如下:LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE] INTO TABLE tablename[PARTITION (partcol1=val1,partcol2=val2,…)]LOC
【图文详细 】Hive的DML操作中Insert 插入数据
语法结构:    1、插入一条数据: INSERT INTO TABLE table_name VALUES(XX,YY,ZZ);    2、利用查询语句将结果导入新表: INSERT OVERWRITE [INTO] TABLE table_name [PARTITION (partcol1=val1, partcol2=val2 ...)] select_statement1 FROM fro...
使用JDBC插入数据记录,只能使用sql语句(insert)吗?
记得asp里头都有rs.addnewrnJDBC有吗?
【求组】PROC的insert语句不能插入数据 貌似和变量有关?
rn代码rntablename这个表只包含一个number字段rnrn在PROC中这样写的代码rnrn unsigned long i =0;rn for(i; i<20; ++i)rn rn EXEC SQL insert into tablename values(i);rn EXEC SQL commit;rn rnrn发现不能添加成功。rn怎么实现好呢?
为什么用循环写出的insert语句不能循环插入数据
源代码如下:rn for i=1 to nrn sql="insert user(username,password) values(xlsheet(i,1),xlsheet(i,2))"rn rs.open sql,ado……rn i=i+1rn next irn xlsheet为一Excel工作表rn 数据库ado连接正常rn 试过分别把insert写两次,可以成功rn
hibernate的hql不能使用insert语句
初次尝试将hibernate加入项目 做一个用户登录的功能 想要选择hibernate的hql做插入动作 发现插入式实现不了的  最后使用sql语句 session.createSQLQuery(sql); 为什么hql语句不能做插入操作呢 因为hql语句是面向对象实现查询功能的 在我们选择插入数据时并没有使用到任何的查询功能,因此导致了hql不能使用insert
C# INSERT INTO 语句的语法错误,求解!!!
string con1 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = ...\data\fileinfosys.mdb;Persist Security Info=False;Jet OLEDB:Database Password=123;";rn string constring = "INSERT INTO [item_directory](id,name,superior,finished,no,pno) VALUES(" + ite.Id + ",'" + ite.Name.ToString() + "'," + ite.Superior + "," + ite.Finished + ",'" + ite.No.ToString() + "','" + ite.ParentNo.ToString() + "')";rnrn OleDbConnection dbCon = new OleDbConnection(con1);rn OleDbCommand dbCmd = new OleDbCommand(constring, dbCon);rn tryrn rn dbCon.Open();rn dbCmd.ExecuteNonQuery();rn rn运行提示:INSERT INTO 语句的语法错误!rn求解?rn谢谢!
菜鸟求助insert 语句的疑惑。着急!熬夜。
问题描述:rn 表registertable有13个数据段:a1.....a13,类型都是char。rn 定义13个变量:b1....b13,数据类型都是string。rn 源代码如下:rn cmm.CommandText = "insert into registertable(a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13) values('" & b1 & "','" & b2 & "','" & b3 & "','" & b4 & "','" & b5 & "','" & b6 & "','" & b7 & "','" & b8 & "','" & b9 & "','" & b10 & "','" & b11 & "','" & b12 & "','" & b13 & "')"rn cmm.ExecuteNonQuery()rn rn 运行时出错,错误描述如下:rn 语句已终止。将截断字符串或二进制数据。 rn 说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。rn 异常详细信息: System.Data.OleDb.OleDbException: 语句已终止。将截断字符串或二进制数据。rnrnrn求教:到底错在哪里??怎么修改????着急!!!跪求!!
HIVE:表中插入数据出错
在hive中创建表t,id int ,name string ,age int如下图 hive&amp;gt; desc t; OK id int name string age int 向表中插入数据 hive&amp;gt; insert into t (id,name,age)...
使用recordset.update和使用insert插入数据有什么区别?
性能一样?
bulk insert语句插入数据时去重
利用bulk insert 语句往表中插入数据,怎么将重复的数据去掉或者更新
关于insert语句插入数据到mysql数据库的问题
$sql="insert into friend_user(userid,name,sfz,race,nation,sex,zhz,birthday,np,pass,repass,sorts,mode,entrance,edu,gra,magra,schmode,specialty,uncode,graun,shcode,schname,massort,masspe,mcode,massch,mascode,masunit,doccode,docunit,docdate,dspecode,docdate,dspecode,docspe,isfirst,teaname,letterid,asssort,pname,pamount,ptheme,ptime,porigin,anstime,psort,apubin,appubout,apubcon,apubcont,sci,ei,istp,awf,awt,awth,awfo,bwf,bwt,bwth,patent,remark) values ('$userid','$name','$sfz','$race','$nation','$sex','$zhz','$birthday','$np','$pass','$repass','$sorts','$mode','$entrance','$edu','$gra','$magra','$schmode','$specialty','$uncode','$graun','$shcode','$schname','$massort','$masspe','$mcode','$massch','$mascode','$masunit','$doccode','$docunit','$docdate','$dspecode','$docdate','$dspecode','$docspe','$isfirst','$teaname','$letterid','$asssort','$pname','$pamount','$ptheme','$ptime','$porigin','$anstime','$psort','$apubin','$appubout','$apubcon','$apubcont','$sci','$ei','$istp','$awf','$awt','$awth','$awfo','$bwf','$bwt','$bwth','$patent','$remark')";rn$result=mysql_query($sql,$db);rnmysql_close($db);rnecho " ";rn是不是insert语句限制一次插入的变量个数?rn为什么总是不能插入数据到数据库?
mybatis的insert语句插入数据时的返回值
mybatis的sql语句一般是配置在配置文件中,现先给出一个例子, sqlMap.xml文件中的一条插入语句: "add" parameterClass="xxx"> insert into A(a, b, c, d) VALUE (#a#, #b#, #c#, #d#) 以上的代码片段只是最简单的插入语句,上面这条SQL语句无论执行结果是
Java mybatis insert语句返回插入数据ID
mybatis插入SQL语句返回该条SQL的ID 将下面两个属性添加到insert标签中 即可得到返回的SQL ID useGeneratedKeys="true" keyProperty="id" 例 insert into risk_client_gs (id,phone, create_time,update_time) values (#{id,jdbcTyp
急: insert 语句插入数据的问题 !!!!!!!1
两个表 TABLE_A 里有字段 A B C D E rn和TABLE_B 里有字段 B C D E(比TABLE_A表里少了一个 'A' 字段 )rn现在想写一条insert 语句 把 TABLE_B里 B ,C,D,E 字段的数据 插入到TABLE_A 的对应字段中 但是在这个过程中要对TABLE_A中的 字段A 赋一个初值 当然这个值是我在程序中传过来的固定值rn请问这样的语句 该怎么写???????rnrn
sql insert语句往数据库插入数据出错
insert语句插入语句中,某字段数据类型为字符型,取得控件text值后,text值中有''存在,插入出错。rn求解决办法。rnrn代码:rn string art_sql = "INSERT INTO [it].[dbo].[Article]([ArticleTitle],[ArticleContent],[UserId],[ArticleTime],[ArticleTypeId])VALUES('" + txtTitle.Text + "','"+Convert.ToString(txtCKEditor.Text.ToString())+"'," + Convert.ToInt32(lblUserId.Text) + ",'" + Convert.ToDateTime(lblTime.Text) + "'," + Convert.ToInt32(ddlArticleType.SelectedValue) + ")";rnrnrn如txtCKEditor.Text中带有',无法正常插入。
向access插入数据,提示insert into语句不对
private void Button1_Click(object sender, System.EventArgs e)rn rn myData.GetExecuteNonQuery("INSERT INTO user (id,password) VALUES ('"+TextBox1.Text+"','"+TextBox2.Text+"')");rn rn rn那里错了,高人指点下!
insert into语句不能向access数据库中添加
代码如下:rnrn<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%> rn rn<% rnrnResponse.Write Request.Servervariables("REQUEST_METHOD")rnrnIf Request.ServerVariables("REQUEST_METHOD")="get" Then rnrnconn.Execute("Insert Into article(title,content,nclassid,user) values('"&Request("title")&"','"&request("content")&"',"&Request("nclassid")&","&Request("user")&")") rnResponse.Redirect "articlelist.asp" rnElse rn%> rn rn rn rn rn 无标题文档 rn rnrn rn rn rn rn 版块: rn rn rn rn 标题: rn rn rnrn rn 发表者: rn rn rn rn 上传时间: rn rn rn rn 上传图片: rn rn rn rn rn 内容: rnrn rn rn rn rn rn rn rn rn rn rn rn rn'<%End If%> rnrn显示数据没问题,在线等
【SQL Server学习笔记】5:使用INSERT语句插入数据
使用SQL语句的意义是,要开发的DBAS应用程序不能像人一样通过SSMS工具来操作数据,SQL语句是应用程序和数据库通信的桥梁。而且相比手动图形化操作,SQL语句更加方便和强大。SQL(结构化查询语言)的组成①DML(数据操作语言) 插入、删除和修改数据库中的数据INSERT、UPDATE、DELETE等②DCL(数据控制语言) 用来控制存储许可,存取权限等GRANT、REVOKE等③DQL(数
INSERT EXEC 语句不能嵌套
[code=SQL]rn CREATE TABLE #RESULT_TABLErn (rn [ID] INT,rn LAC INT,rn CI INT,rn Traffic FLOAT,rn [Load] FLOAT, rn Rate VARCHAR(50),rnrn longitude INT,rn latitude INT,rn Rxlev INTrn )rnrn INSERT #RESULT_TABLE EXEC P_HIGH_CALL '2009030110'rn[/code]rnrn我写了一个存储过程:P_HIGH_CALL 将返回一个结果集,如下:rn1 4272 5065 27.700001 21.30946667 76.93% 116387 39897 -71rn2 4272 5066 33.099998 23.2516 70.25% 116387 39897 -73rn3 4272 5196 22.4 16.4588 73.48% 116383 39899 -67rn4 4272 10549 7.25 5.326266667 73.47% 116383 39899 -65rn5 4272 11361 11.26 7.619733333 67.67% 116396 39901 -69rn6 4272 20103 2.88 1.956533333 67.94% 116394 39899 -56rnrn我想将这个结果集放到一个临时表里,可执行后提示 INSERT EXEC 语句不能嵌套rn请高手帮忙解决一下,很急的。。。谢啦。rnrnrn
hive执行insert语句时报错
错误提示如下: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask MapReduce Jobs Launched: Stage-Stage-1: HDFS Read: 0 HDFS Write: 0 FAIL resolution...
hadoop hive insert 语句 map 如何并行执行
我的一个hive语句执行时,日志串行打印很多map,但reduce=0%,速度很慢rn我有三个slave机,请问这个是一个什么情况?有没有充分利用slave机?如何优化这个步骤?rnrnhive>insert overwrite table archive_seller_by_geo_per_day partition(partDate, shard) select sellerTokenID, partDate archiveDate, countryCode, country, countryState, countryCity, count(*) pv, count(distinct ip) uv, partDate, shard from page_visit where partDate >= 20140105 and partDate <= 20140107 group by sellerTokenID, countryCode, country, countryState, countryCity, partDate, shard having sellerTokenID>0;rnTotal MapReduce jobs = 1rnLaunching Job 1 out of 1rnNumber of reduce tasks not specified. Estimated from input data size: 2rnIn order to change the average load for a reducer (in bytes):rn set hive.exec.reducers.bytes.per.reducer=rnIn order to limit the maximum number of reducers:rn set hive.exec.reducers.max=rnIn order to set a constant number of reducers:rn set mapred.reduce.tasks=rn14/01/06 02:19:04 WARN conf.Configuration: file:/tmp/hadoop/hive_2014-01-06_02-18-36_965_8368468299913664807/-local-10002/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval; Ignoring.rn14/01/06 02:19:04 WARN conf.Configuration: file:/tmp/hadoop/hive_2014-01-06_02-18-36_965_8368468299913664807/-local-10002/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts; Ignoring.rn14/01/06 02:19:05 INFO Configuration.deprecation: mapred.input.dir.recursive is deprecated. Instead, use mapreduce.input.fileinputformat.input.dir.recursivern14/01/06 02:19:05 INFO Configuration.deprecation: mapred.max.split.size is deprecated. Instead, use mapreduce.input.fileinputformat.split.maxsizern14/01/06 02:19:05 INFO Configuration.deprecation: mapred.min.split.size is deprecated. Instead, use mapreduce.input.fileinputformat.split.minsizern14/01/06 02:19:05 INFO Configuration.deprecation: mapred.min.split.size.per.rack is deprecated. Instead, use mapreduce.input.fileinputformat.split.minsize.per.rackrn14/01/06 02:19:05 INFO Configuration.deprecation: mapred.min.split.size.per.node is deprecated. Instead, use mapreduce.input.fileinputformat.split.minsize.per.nodern14/01/06 02:19:05 INFO Configuration.deprecation: mapred.reduce.tasks is deprecated. Instead, use mapreduce.job.reducesrn14/01/06 02:19:05 INFO Configuration.deprecation: mapred.reduce.tasks.speculative.execution is deprecated. Instead, use mapreduce.reduce.speculativern14/01/06 02:19:08 WARN conf.Configuration: org.apache.hadoop.hive.conf.LoopingByteArrayInputStream@6a360482:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval; Ignoring.rn14/01/06 02:19:08 WARN conf.Configuration: org.apache.hadoop.hive.conf.LoopingByteArrayInputStream@6a360482:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts; Ignoring.rnExecution log at: /tmp/hadoop/.logrnJob running in-process (local Hadoop)rnHadoop job information for null: number of mappers: 0; number of reducers: 0rn2014-01-06 02:19:27,729 null map = 0%, reduce = 0%rn2014-01-06 02:19:42,975 null map = 2%, reduce = 0%rn2014-01-06 02:20:00,596 null map = 7%, reduce = 0%rn2014-01-06 02:20:22,024 null map = 11%, reduce = 0%rn2014-01-06 02:20:25,652 null map = 100%, reduce = 0%rn2014-01-06 02:20:27,884 null map = 17%, reduce = 0%rn2014-01-06 02:20:31,367 null map = 18%, reduce = 0%rn2014-01-06 02:20:49,400 null map = 23%, reduce = 0%rn2014-01-06 02:21:03,890 null map = 28%, reduce = 0%rn2014-01-06 02:21:07,375 null map = 100%, reduce = 0%rn2014-01-06 02:21:10,657 null map = 34%, reduce = 0%rn2014-01-06 02:21:28,432 null map = 39%, reduce = 0%rn2014-01-06 02:21:46,567 null map = 44%, reduce = 0%rn2014-01-06 02:21:48,837 null map = 100%, reduce = 0%rn2014-01-06 02:21:52,033 null map = 51%, reduce = 0%rn2014-01-06 02:22:12,806 null map = 56%, reduce = 0%rn2014-01-06 02:22:27,888 null map = 61%, reduce = 0%rn2014-01-06 02:22:30,166 null map = 100%, reduce = 0%rn2014-01-06 02:22:32,426 null map = 67%, reduce = 0%rn2014-01-06 02:22:48,425 null map = 72%, reduce = 0%rn2014-01-06 02:23:06,230 null map = 100%, reduce = 0%rn2014-01-06 02:23:09,829 null map = 83%, reduce = 0%rn2014-01-06 02:23:15,249 null map = 86%, reduce = 0%rn2014-01-06 02:23:21,892 null map = 89%, reduce = 0%rn2014-01-06 02:23:27,270 null map = 92%, reduce = 0%rn2014-01-06 02:23:37,087 null map = 100%, reduce = 0%rn2014-01-06 02:23:43,194 null map = 100%, reduce = 67%rn2014-01-06 02:23:45,547 null map = 100%, reduce = 68%rn2014-01-06 02:23:48,773 null map = 100%, reduce = 69%rn2014-01-06 02:23:52,135 null map = 100%, reduce = 70%rn2014-01-06 02:23:54,277 null map = 100%, reduce = 72%rn2014-01-06 02:23:57,674 null map = 100%, reduce = 73%rn2014-01-06 02:24:01,048 null map = 100%, reduce = 74%rn2014-01-06 02:24:03,247 null map = 100%, reduce = 76%rn2014-01-06 02:24:06,519 null map = 100%, reduce = 77%rn2014-01-06 02:24:09,693 null map = 100%, reduce = 78%rn2014-01-06 02:24:12,980 null map = 100%, reduce = 80%rn2014-01-06 02:24:16,241 null map = 100%, reduce = 81%rn2014-01-06 02:24:18,457 null map = 100%, reduce = 83%rn2014-01-06 02:24:21,897 null map = 100%, reduce = 84%rn2014-01-06 02:24:25,186 null map = 100%, reduce = 85%rn2014-01-06 02:24:28,507 null map = 100%, reduce = 87%rn2014-01-06 02:24:30,665 null map = 100%, reduce = 88%rn2014-01-06 02:24:33,914 null map = 100%, reduce = 89%rn2014-01-06 02:24:37,298 null map = 100%, reduce = 91%rn2014-01-06 02:24:40,471 null map = 100%, reduce = 92%rn2014-01-06 02:24:42,756 null map = 100%, reduce = 94%rn2014-01-06 02:24:45,976 null map = 100%, reduce = 95%rn2014-01-06 02:24:49,141 null map = 100%, reduce = 97%rn2014-01-06 02:24:52,374 null map = 100%, reduce = 98%rn2014-01-06 02:24:55,659 null map = 100%, reduce = 99%rn2014-01-06 02:24:57,791 null map = 100%, reduce = 100%rnEnded Job = job_local72828086_0001rnExecution completed successfullyrnMapred Local Task Succeeded . Convert the Join into MapJoinrnLoading data to table default.archive_seller_by_geo_per_day partition (partdate=null, shard=null)rnrmr: DEPRECATED: Please use 'rm -r' instead.rnDeleted hdfs://master-hadoop:9000/hive/archive_seller_by_geo_per_day/partdate=20140105/shard=1rnrmr: DEPRECATED: Please use 'rm -r' instead.rnDeleted hdfs://master-hadoop:9000/hive/archive_seller_by_geo_per_day/partdate=20140106/shard=1rnrmr: DEPRECATED: Please use 'rm -r' instead.rnDeleted hdfs://master-hadoop:9000/hive/archive_seller_by_geo_per_day/partdate=20140105/shard=3rnrmr: DEPRECATED: Please use 'rm -r' instead.rnDeleted hdfs://master-hadoop:9000/hive/archive_seller_by_geo_per_day/partdate=20140106/shard=3rnrmr: DEPRECATED: Please use 'rm -r' instead.rnDeleted hdfs://master-hadoop:9000/hive/archive_seller_by_geo_per_day/partdate=20140106/shard=2rnrmr: DEPRECATED: Please use 'rm -r' instead.rnDeleted hdfs://master-hadoop:9000/hive/archive_seller_by_geo_per_day/partdate=20140105/shard=2rn Loading partition partdate=20140105, shard=1rn Loading partition partdate=20140106, shard=1rn Loading partition partdate=20140105, shard=3rn Loading partition partdate=20140106, shard=3rn Loading partition partdate=20140106, shard=2rn Loading partition partdate=20140105, shard=2rnPartition default.archive_seller_by_geo_per_daypartdate=20140105, shard=1 stats: [num_files: 1, num_rows: 389658, total_size: 22437233, raw_data_size: 22047575]rnPartition default.archive_seller_by_geo_per_daypartdate=20140105, shard=2 stats: [num_files: 1, num_rows: 280992, total_size: 16258941, raw_data_size: 15977949]rnPartition default.archive_seller_by_geo_per_daypartdate=20140105, shard=3 stats: [num_files: 1, num_rows: 297614, total_size: 17215243, raw_data_size: 16917629]rnPartition default.archive_seller_by_geo_per_daypartdate=20140106, shard=1 stats: [num_files: 1, num_rows: 43019, total_size: 2416280, raw_data_size: 2373261]rnPartition default.archive_seller_by_geo_per_daypartdate=20140106, shard=2 stats: [num_files: 1, num_rows: 26407, total_size: 1485594, raw_data_size: 1459187]rnPartition default.archive_seller_by_geo_per_daypartdate=20140106, shard=3 stats: [num_files: 1, num_rows: 38030, total_size: 2141012, raw_data_size: 2102982]rnTable default.archive_seller_by_geo_per_day stats: [num_partitions: 15, num_files: 15, num_rows: 4597123, total_size: 265138697, raw_data_size: 260541574]rnOKrnTime taken: 391.872 secondsrn
INSERT EXEC 语句不能嵌套。
[code=SQL]Create PROCEDURE a rn....rninsert #temprnexec brn...rnrnCreate PROCEDURE brn..rn@sql = ...rninsert #temprnexec @sqlrn..[/code]rn执行 a 提示:INSERT EXEC 语句不能嵌套。rn该如何解决呢?rnrn
INSERT EXEC 语句不能嵌套!!!!!!
大家帮忙看下面这个过程啊,执行下面的过程,就会报错,如题……rnrn--创建测试的临时过程rnrnCREATE PROCEDURE #P_Test01rnASrnrnSELECT *rnINTO #Temp01rnFROM syscolumnsrnWHERE 1<>1rn--rnrnINSERT #Temp01rnEXEC('SELECT TOP 100 * FROM SYSCOLUMNS')rnrn--rnSELECT *rnFROM #Temp01rn--END 创建过程完毕rnrn--执行过程rnrnSELECT *rnINTO #Temp02rnFROM syscolumnsrnWHERE 1<>1rnrnrnINSERT #Temp02rnEXEC #P_Test01rnrnrn就会报错:INSERT EXEC 语句不能嵌套。rnrn请帮忙解释报这个错的原因,我做了很多测试,知道一旦采用这种插入数据的方式,就会报这样的错rn但是我想知道,这个方式违反了SQL SEVER的什么原则,还有……
相关热词 c#入门推荐书 c# 解码海康数据流 c# xml的遍历循环 c# 取 查看源码没有的 c#解决高并发 委托 c#日期转化为字符串 c# 显示问号 c# 字典对象池 c#5.0 安装程序 c# 分页算法