Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] No Matching column #1161

Closed
marsishandsome opened this issue Oct 21, 2019 · 1 comment
Closed

[BUG] No Matching column #1161

marsishandsome opened this issue Oct 21, 2019 · 1 comment
Assignees
Labels

Comments

@marsishandsome
Copy link
Collaborator

CREATE TABLE `t_no_match_column` (
  `json` text DEFAULT NULL
)
select temp44.id from (
    SELECT get_json_object(t.json,  '$.id') as id from t_no_match_column t
) as temp44 order by temp44.id desc limit 1
No Matching column id from table t_no_match_column
com.pingcap.tikv.exception.TiExpressionException: No Matching column id from table t_no_match_column
	at com.pingcap.tikv.expression.ColumnRef.resolve(ColumnRef.java:71)
	at com.pingcap.tikv.expression.visitor.MetaResolver.visit(MetaResolver.java:52)
	at com.pingcap.tikv.expression.visitor.MetaResolver.visit(MetaResolver.java:24)
	at com.pingcap.tikv.expression.ColumnRef.accept(ColumnRef.java:141)
	at com.pingcap.tikv.expression.visitor.MetaResolver.lambda$resolve$0(MetaResolver.java:42)
	at java.lang.Iterable.forEach(Iterable.java:75)
	at com.pingcap.tikv.expression.visitor.MetaResolver.resolve(MetaResolver.java:42)
	at com.pingcap.tikv.meta.TiDAGRequest.resolve(TiDAGRequest.java:264)
	at org.apache.spark.sql.TiStrategy.toCoprocessorRDD(TiStrategy.scala:159)
	at org.apache.spark.sql.TiStrategy.pruneFilterProject(TiStrategy.scala:416)
	at org.apache.spark.sql.TiStrategy.pruneTopNFilterProject(TiStrategy.scala:312)
	at org.apache.spark.sql.TiStrategy.takeOrderedAndProject(TiStrategy.scala:351)
	at org.apache.spark.sql.TiStrategy.org$apache$spark$sql$TiStrategy$$doPlan(TiStrategy.scala:521)
	at org.apache.spark.sql.TiStrategy$$anonfun$apply$1.applyOrElse(TiStrategy.scala:146)
	at org.apache.spark.sql.TiStrategy$$anonfun$apply$1.applyOrElse(TiStrategy.scala:144)
@birdstorm
Copy link
Contributor

Closed in #1163

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants