Build #144379

Environment variables

NameValue
ANDROID_HOME/home/android-sdk/
AWS_ACCESS_KEY_ID[*******]
AWS_SECRET_ACCESS_KEY[*******]
BUILD_CAUSEGHPRBCAUSE
BUILD_CAUSE_GHPRBCAUSEtrue
BUILD_DISPLAY_NAME#144379
BUILD_ID144379
BUILD_NUMBER144379
BUILD_TAGjenkins-SparkPullRequestBuilder-144379
BUILD_URLhttps://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/144379/
CLASSPATH$CLASSPATH
DBUS_SESSION_BUS_ADDRESSunix:path=/run/user/1001/bus
EXECUTOR_NUMBER1
GITHUB_OAUTH_KEY[*******]
GIT_BRANCHindex_syntax
GIT_COMMIT04e6a2f4617b25e8ee26b1d545db7510d083ee60
GIT_PREVIOUS_COMMIT2319523b1001a1580b9abe03174bd8dee2df962f
GIT_PREVIOUS_SUCCESSFUL_COMMIT2319523b1001a1580b9abe03174bd8dee2df962f
GIT_URLhttps://github.com/apache/spark.git
HOME/home/jenkins
HUDSON_HOME/var/lib/jenkins
HUDSON_SERVER_COOKIE472906e9832aeb79
HUDSON_URLhttps://amplab.cs.berkeley.edu/jenkins/
JAVA_HOME/usr/java/latest
JENKINS_HOME/var/lib/jenkins
JENKINS_SERVER_COOKIE472906e9832aeb79
JENKINS_URLhttps://amplab.cs.berkeley.edu/jenkins/
JOB_BASE_NAMESparkPullRequestBuilder
JOB_NAMESparkPullRequestBuilder
JOB_URLhttps://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/
LANGen_US.UTF-8
LOGNAMEjenkins
MOTD_SHOWNpam
NODE_LABELSresearch-jenkins-worker-01 ubuntu ubuntu20 worker-01
NODE_NAMEresearch-jenkins-worker-01
OLDPWD/home/jenkins
PATH/home/jenkins/tools/hudson.tasks.Maven_MavenInstallation/Maven_3.6.3/bin/:/home/jenkins/gems/bin:/usr/local/go/bin:/home/jenkins/go-projects/bin:/home/jenkins/anaconda2/bin:/home/jenkins/tools/hudson.tasks.Maven_MavenInstallation/Maven_3.6.3/bin/:/home/jenkins/gems/bin:/usr/local/go/bin:/home/jenkins/go-projects/bin:/home/jenkins/anaconda2/bin:$PATH
PWD/home/jenkins
ROOT_BUILD_CAUSEGHPRBCAUSE
ROOT_BUILD_CAUSE_GHPRBCAUSEtrue
RUN_ARTIFACTS_DISPLAY_URLhttps://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/144379/display/redirect?page=artifacts
RUN_CHANGES_DISPLAY_URLhttps://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/144379/display/redirect?page=changes
RUN_DISPLAY_URLhttps://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/144379/display/redirect
RUN_TESTS_DISPLAY_URLhttps://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/144379/display/redirect?page=tests
SHELL/bin/bash
SHLVL0
SPARK_TEST_KEY[*******]
SSH_CLIENT192.168.10.11 55534 22
SSH_CONNECTION192.168.10.11 55534 192.168.10.21 22
USERjenkins
WORKSPACE/home/jenkins/workspace/SparkPullRequestBuilder
XDG_RUNTIME_DIR/run/user/1001
XDG_SESSION_CLASSuser
XDG_SESSION_ID1
XDG_SESSION_TYPEtty
_/usr/java/latest/bin/java
ghprbActualCommit8eb052a5d2b17ed0dd07ca93514348357ffe400c
ghprbActualCommitAuthorHuaxin Gao
ghprbActualCommitAuthorEmailhuaxin_gao@apple.com
ghprbAuthorRepoGitUrlhttps://github.com/huaxingao/spark.git
ghprbCommentBodynull
ghprbCredentialsIdb7d94526-9e9b-435f-9275-d7dbf209f4a3
ghprbGhRepositoryapache/spark
ghprbPullAuthorEmailhuaxin.gao11@gmail.com
ghprbPullAuthorLoginhuaxingao
ghprbPullAuthorLoginMention@huaxingao
ghprbPullDescriptionGitHub pull request #34148 of commit 8eb052a5d2b17ed0dd07ca93514348357ffe400c, no merge conflicts.
ghprbPullId34148
ghprbPullLinkhttps://github.com/apache/spark/pull/34148
ghprbPullLongDescription### What changes were proposed in this pull request?\r\nThis is the 2nd PR for DSv2 index support.\r\n\r\nThis PR adds the following:\r\n\r\n- create index syntax support in parser and analyzer\r\n- `CreateIndex` logic node\r\n- `CreateIndexExec` physical node\r\n\r\n`CreateIndex` is not implemented yet in this PR. Calling `CreateIndex` will throw `SQLFeatureNotSupportedException`, and the parsed index information such as `IndexName` `indexType` `columns` and index properties will be included in the error message for now for testing purpose.\r\n\r\n### Why are the changes needed?\r\nTo support index in DSv2\r\n\r\n\r\n### Does this PR introduce _any_ user-facing change?\r\nYes, the create table syntax as the following:\r\n\r\n```\r\nCREATE INDEX index_name ON [TABLE] table_name [USING index_type] (column_index_property_list)[OPTIONS indexPropertyList]\r\n\r\n    column_index_property_list: column_name [OPTIONS(indexPropertyList)]  [ ,  . . . ]\r\n    indexPropertyList: index_property_name [= index_property_value] [ ,  . . . ]\r\n```\r\n\r\n### How was this patch tested?\r\nadd a UT
ghprbPullTitle[SPARK-36895][SQL] Add Create Index syntax support
ghprbSourceBranchindex_syntax
ghprbTargetBranchmaster
ghprbTriggerAuthor
ghprbTriggerAuthorEmail
ghprbTriggerAuthorLogin
ghprbTriggerAuthorLoginMention
sha1origin/pr/34148/merge