[
https://issues.apache.org/jira/browse/CARBONDATA-1153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
cen yuhai updated CARBONDATA-1153:
----------------------------------
Description:
Sometimes it will throws exception as below. why can't I add column? no one are
altering the table...
{code}
scala> carbon.sql("alter table temp.yuhai_carbon add columns(test1 string)")
17/06/11 22:09:13 AUDIT
[org.apache.spark.sql.execution.command.AlterTableAddColumns(207) -- main]:
[sh-hadoop-datanode-250-104.elenet.me][master][Thread-1]Alter table add columns
request has been received for temp.yuhai_carbon
17/06/11 22:10:22 ERROR [org.apache.spark.scheduler.TaskSetManager(70) --
task-result-getter-3]: Task 0 in stage 0.0 failed 4 times; aborting job
17/06/11 22:10:22 ERROR
[org.apache.spark.sql.execution.command.AlterTableAddColumns(141) -- main]:
main Alter table add columns failed :Job aborted due to stage failure: Task 0
in stage 0.0 failed 4 times, most recent failure: Lost task 0.3 in stage 0.0
(TID 3, sh-hadoop-datanode-368.elenet.me, executor 7):
java.lang.RuntimeException: Dictionary file test1 is locked for updation.
Please try after some time
at scala.sys.package$.error(package.scala:27)
at
org.apache.carbondata.spark.util.GlobalDictionaryUtil$.loadDefaultDictionaryValueForNewColumn(GlobalDictionaryUtil.scala:857)
at
org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD$$anon$1.<init>(AlterTableAddColumnRDD.scala:83)
at
org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD.compute(AlterTableAddColumnRDD.scala:68)
at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:331)
at org.apache.spark.rdd.RDD.iterator(RDD.scala:295)
at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:88)
at org.apache.spark.scheduler.Task.run(Task.scala:104)
at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:351)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
{code}
was:
why can't I add column? no one are altering the table...
{code}
scala> carbon.sql("alter table temp.yuhai_carbon add columns(test1 string)")
17/06/11 22:09:13 AUDIT
[org.apache.spark.sql.execution.command.AlterTableAddColumns(207) -- main]:
[sh-hadoop-datanode-250-104.elenet.me][master][Thread-1]Alter table add columns
request has been received for temp.yuhai_carbon
17/06/11 22:10:22 ERROR [org.apache.spark.scheduler.TaskSetManager(70) --
task-result-getter-3]: Task 0 in stage 0.0 failed 4 times; aborting job
17/06/11 22:10:22 ERROR
[org.apache.spark.sql.execution.command.AlterTableAddColumns(141) -- main]:
main Alter table add columns failed :Job aborted due to stage failure: Task 0
in stage 0.0 failed 4 times, most recent failure: Lost task 0.3 in stage 0.0
(TID 3, sh-hadoop-datanode-368.elenet.me, executor 7):
java.lang.RuntimeException: Dictionary file test1 is locked for updation.
Please try after some time
at scala.sys.package$.error(package.scala:27)
at
org.apache.carbondata.spark.util.GlobalDictionaryUtil$.loadDefaultDictionaryValueForNewColumn(GlobalDictionaryUtil.scala:857)
at
org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD$$anon$1.<init>(AlterTableAddColumnRDD.scala:83)
at
org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD.compute(AlterTableAddColumnRDD.scala:68)
at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:331)
at org.apache.spark.rdd.RDD.iterator(RDD.scala:295)
at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:88)
at org.apache.spark.scheduler.Task.run(Task.scala:104)
at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:351)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
{code}
> Can not add column because it is aborted
> ----------------------------------------
>
> Key: CARBONDATA-1153
> URL: https://issues.apache.org/jira/browse/CARBONDATA-1153
> Project: CarbonData
> Issue Type: Bug
> Components: spark-integration
> Affects Versions: 1.2.0
> Reporter: cen yuhai
>
> Sometimes it will throws exception as below. why can't I add column? no one
> are altering the table...
> {code}
> scala> carbon.sql("alter table temp.yuhai_carbon add columns(test1 string)")
> 17/06/11 22:09:13 AUDIT
> [org.apache.spark.sql.execution.command.AlterTableAddColumns(207) -- main]:
> [sh-hadoop-datanode-250-104.elenet.me][master][Thread-1]Alter table add
> columns request has been received for temp.yuhai_carbon
> 17/06/11 22:10:22 ERROR [org.apache.spark.scheduler.TaskSetManager(70) --
> task-result-getter-3]: Task 0 in stage 0.0 failed 4 times; aborting job
> 17/06/11 22:10:22 ERROR
> [org.apache.spark.sql.execution.command.AlterTableAddColumns(141) -- main]:
> main Alter table add columns failed :Job aborted due to stage failure: Task 0
> in stage 0.0 failed 4 times, most recent failure: Lost task 0.3 in stage 0.0
> (TID 3, sh-hadoop-datanode-368.elenet.me, executor 7):
> java.lang.RuntimeException: Dictionary file test1 is locked for updation.
> Please try after some time
> at scala.sys.package$.error(package.scala:27)
> at
> org.apache.carbondata.spark.util.GlobalDictionaryUtil$.loadDefaultDictionaryValueForNewColumn(GlobalDictionaryUtil.scala:857)
> at
> org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD$$anon$1.<init>(AlterTableAddColumnRDD.scala:83)
> at
> org.apache.carbondata.spark.rdd.AlterTableAddColumnRDD.compute(AlterTableAddColumnRDD.scala:68)
> at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:331)
> at org.apache.spark.rdd.RDD.iterator(RDD.scala:295)
> at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:88)
> at org.apache.spark.scheduler.Task.run(Task.scala:104)
> at
> org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:351)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
