hvanhovell commented on code in PR #40160:
URL: https://github.com/apache/spark/pull/40160#discussion_r1120265749
##########
connector/connect/server/src/main/scala/org/apache/spark/sql/connect/planner/SparkConnectPlanner.scala:
##########
@@ -1450,10 +1458,78 @@ class SparkConnectPlanner(val session: SparkSession) {
handleWriteOperationV2(command.getWriteOperationV2)
case proto.Command.CommandTypeCase.EXTENSION =>
handleCommandPlugin(command.getExtension)
+ case proto.Command.CommandTypeCase.SQL_COMMAND =>
+ handleSqlCommand(command.getSqlCommand, clientId, responseObserver)
case _ => throw new UnsupportedOperationException(s"$command not
supported.")
}
}
+ def handleSqlCommand(
+ getSqlCommand: SqlCommand,
+ clientId: String,
+ responseObserver: StreamObserver[ExecutePlanResponse]): Unit = {
+ // Eagerly execute commands of the provided SQL string.
+ val df = session.sql(getSqlCommand.getSql, getSqlCommand.getArgsMap)
+ // Check if commands have been executed.
+ val isCommand =
df.queryExecution.commandExecuted.isInstanceOf[CommandResult]
+ val rows = df.logicalPlan match {
+ case lr: LocalRelation => lr.data
+ case cr: CommandResult => cr.rows
+ case _ => Seq.empty
+ }
+
+ // Convert the results to Arrow.
+ val schema = df.schema
+ val maxRecordsPerBatch = session.sessionState.conf.arrowMaxRecordsPerBatch
+ val maxBatchSize =
(SparkEnv.get.conf.get(CONNECT_GRPC_ARROW_MAX_BATCH_SIZE) * 0.7).toLong
+ val timeZoneId = session.sessionState.conf.sessionLocalTimeZone
+
+ // Convert the data.
+ val bytes = if (rows.isEmpty) {
+ ArrowConverters.createEmptyArrowBatch(schema, timeZoneId)
+ } else {
+ val batches = ArrowConverters.toBatchWithSchemaIterator(
+ rows.iterator,
+ schema,
+ maxRecordsPerBatch,
+ maxBatchSize,
+ timeZoneId)
+ batches.reduce(_ ++ _)
Review Comment:
Is our reading code clever enough for this?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
