[ 
https://issues.apache.org/jira/browse/SPARK-35797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

YuanGuanhu updated SPARK-35797:
-------------------------------
    Description: 
we are using hue to connect Spark JDBCServer with spark3.1.1, when we queru 
this `select * from tb1` we got this exception:
{code:java}
// code placeholder
{code}
2021-06-09 19:44:46,918 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | 
Closed a connection to metastore, current connections: 1 | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.close(HiveMetaStoreClient.java:804)2021-06-09
 19:44:46,918 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Closed a 
connection to metastore, current connections: 1 | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.close(HiveMetaStoreClient.java:804)2021-06-09
 19:44:46,926 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Trying to 
connect to metastore with URI thrift://xxxx:21088 | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:583)2021-06-09
 19:44:46,927 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | HMSC::open(): 
Found delegation token. Creating DIGEST-based thrift connection. | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:639)2021-06-09
 19:44:46,927 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Whether to use 
hadoop rpc protection: true | 
org.apache.hadoop.hive.metastore.utils.MetaStoreUtils.getMetaStoreSaslProperties(MetaStoreUtils.java:1119)2021-06-09
 19:44:47,030 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Opened a 
connection to metastore, current connections: 2 | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:672)2021-06-09
 19:44:47,031 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Connected to 
metastore. | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:768)2021-06-09
 19:44:47,032 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | 
RetryingMetaStoreClient proxy=class 
org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient ugi=admintest 
(auth:PROXY) via spark2x/hadoop.hadoop....@hadoop.com (auth:KERBEROS) retries=1 
delay=1 lifetime=0 | 
org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:99)2021-06-09
 19:44:47,042 | ERROR | [HiveServer2-Handler-Pool: Thread-227] | Error 
operating GET_SCHEMAS with 0d9c1722-508b-46c3-a61d-4bc8da2b8ce8 | 
org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.logError(Logging.scala:94)java.util.regex.PatternSyntaxException:
 Dangling meta character '*' near index 0*^ at 
java.util.regex.Pattern.error(Pattern.java:1969) at 
java.util.regex.Pattern.sequence(Pattern.java:2137) at 
java.util.regex.Pattern.expr(Pattern.java:2010) at 
java.util.regex.Pattern.compile(Pattern.java:1702) at 
java.util.regex.Pattern.<init>(Pattern.java:1352) at 
java.util.regex.Pattern.compile(Pattern.java:1028) at 
org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.runInternal(SparkGetSchemasOperation.scala:76)
 at org.apache.hive.service.cli.operation.Operation.run(Operation.java:276) at 
org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.org$apache$spark$sql$hive$thriftserver$SparkOperation$$super$run(SparkGetSchemasOperation.scala:39)
 at 
org.apache.spark.sql.hive.thriftserver.SparkOperation.$anonfun$run$1(SparkOperation.scala:44)
 at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) at 
org.apache.spark.sql.hive.thriftserver.SparkOperation.withLocalProperties(SparkOperation.scala:78)
 at 
org.apache.spark.sql.hive.thriftserver.SparkOperation.withLocalProperties$(SparkOperation.scala:62)
 at 
org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.withLocalProperties(SparkGetSchemasOperation.scala:39)
 at 
org.apache.spark.sql.hive.thriftserver.SparkOperation.run(SparkOperation.scala:44)
 at 
org.apache.spark.sql.hive.thriftserver.SparkOperation.run$(SparkOperation.scala:42)
 at 
org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.run(SparkGetSchemasOperation.scala:39)
 at 
org.apache.hive.service.cli.session.HiveSessionImpl.getSchemas(HiveSessionImpl.java:535)

 

  was:
we are using hue to connect Spark JDBCServer with spark3.1.1, when we queru 
this `select * from tb1` we got this exception:
{code:java}
// code placeholder
{code}
2021-06-09 19:44:46,918 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | 
Closed a connection to metastore, current connections: 1 | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.close(HiveMetaStoreClient.java:804)2021-06-09
 19:44:46,918 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Closed a 
connection to metastore, current connections: 1 | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.close(HiveMetaStoreClient.java:804)2021-06-09
 19:44:46,926 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Trying to 
connect to metastore with URI thrift://8-5-248-4:21088 | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:583)2021-06-09
 19:44:46,927 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | HMSC::open(): 
Found delegation token. Creating DIGEST-based thrift connection. | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:639)2021-06-09
 19:44:46,927 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Whether to use 
hadoop rpc protection: true | 
org.apache.hadoop.hive.metastore.utils.MetaStoreUtils.getMetaStoreSaslProperties(MetaStoreUtils.java:1119)2021-06-09
 19:44:47,030 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Opened a 
connection to metastore, current connections: 2 | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:672)2021-06-09
 19:44:47,031 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Connected to 
metastore. | 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:768)2021-06-09
 19:44:47,032 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | 
RetryingMetaStoreClient proxy=class 
org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient ugi=admintest 
(auth:PROXY) via spark2x/hadoop.hadoop....@hadoop.com (auth:KERBEROS) retries=1 
delay=1 lifetime=0 | 
org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:99)2021-06-09
 19:44:47,042 | ERROR | [HiveServer2-Handler-Pool: Thread-227] | Error 
operating GET_SCHEMAS with 0d9c1722-508b-46c3-a61d-4bc8da2b8ce8 | 
org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.logError(Logging.scala:94)java.util.regex.PatternSyntaxException:
 Dangling meta character '*' near index 0*^ at 
java.util.regex.Pattern.error(Pattern.java:1969) at 
java.util.regex.Pattern.sequence(Pattern.java:2137) at 
java.util.regex.Pattern.expr(Pattern.java:2010) at 
java.util.regex.Pattern.compile(Pattern.java:1702) at 
java.util.regex.Pattern.<init>(Pattern.java:1352) at 
java.util.regex.Pattern.compile(Pattern.java:1028) at 
org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.runInternal(SparkGetSchemasOperation.scala:76)
 at org.apache.hive.service.cli.operation.Operation.run(Operation.java:276) at 
org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.org$apache$spark$sql$hive$thriftserver$SparkOperation$$super$run(SparkGetSchemasOperation.scala:39)
 at 
org.apache.spark.sql.hive.thriftserver.SparkOperation.$anonfun$run$1(SparkOperation.scala:44)
 at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) at 
org.apache.spark.sql.hive.thriftserver.SparkOperation.withLocalProperties(SparkOperation.scala:78)
 at 
org.apache.spark.sql.hive.thriftserver.SparkOperation.withLocalProperties$(SparkOperation.scala:62)
 at 
org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.withLocalProperties(SparkGetSchemasOperation.scala:39)
 at 
org.apache.spark.sql.hive.thriftserver.SparkOperation.run(SparkOperation.scala:44)
 at 
org.apache.spark.sql.hive.thriftserver.SparkOperation.run$(SparkOperation.scala:42)
 at 
org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.run(SparkGetSchemasOperation.scala:39)
 at 
org.apache.hive.service.cli.session.HiveSessionImpl.getSchemas(HiveSessionImpl.java:535)

 


> patternToRegex failed when pattern is star
> ------------------------------------------
>
>                 Key: SPARK-35797
>                 URL: https://issues.apache.org/jira/browse/SPARK-35797
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 3.1.1, 3.1.2
>         Environment: Spark 3.1.1
>            Reporter: YuanGuanhu
>            Priority: Major
>
> we are using hue to connect Spark JDBCServer with spark3.1.1, when we queru 
> this `select * from tb1` we got this exception:
> {code:java}
> // code placeholder
> {code}
> 2021-06-09 19:44:46,918 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | 
> Closed a connection to metastore, current connections: 1 | 
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.close(HiveMetaStoreClient.java:804)2021-06-09
>  19:44:46,918 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Closed a 
> connection to metastore, current connections: 1 | 
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.close(HiveMetaStoreClient.java:804)2021-06-09
>  19:44:46,926 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Trying to 
> connect to metastore with URI thrift://xxxx:21088 | 
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:583)2021-06-09
>  19:44:46,927 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | 
> HMSC::open(): Found delegation token. Creating DIGEST-based thrift 
> connection. | 
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:639)2021-06-09
>  19:44:46,927 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Whether to 
> use hadoop rpc protection: true | 
> org.apache.hadoop.hive.metastore.utils.MetaStoreUtils.getMetaStoreSaslProperties(MetaStoreUtils.java:1119)2021-06-09
>  19:44:47,030 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Opened a 
> connection to metastore, current connections: 2 | 
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:672)2021-06-09
>  19:44:47,031 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | Connected to 
> metastore. | 
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:768)2021-06-09
>  19:44:47,032 | INFO  | [HiveServer2-Handler-Pool: Thread-227] | 
> RetryingMetaStoreClient proxy=class 
> org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient ugi=admintest 
> (auth:PROXY) via spark2x/hadoop.hadoop....@hadoop.com (auth:KERBEROS) 
> retries=1 delay=1 lifetime=0 | 
> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:99)2021-06-09
>  19:44:47,042 | ERROR | [HiveServer2-Handler-Pool: Thread-227] | Error 
> operating GET_SCHEMAS with 0d9c1722-508b-46c3-a61d-4bc8da2b8ce8 | 
> org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.logError(Logging.scala:94)java.util.regex.PatternSyntaxException:
>  Dangling meta character '*' near index 0*^ at 
> java.util.regex.Pattern.error(Pattern.java:1969) at 
> java.util.regex.Pattern.sequence(Pattern.java:2137) at 
> java.util.regex.Pattern.expr(Pattern.java:2010) at 
> java.util.regex.Pattern.compile(Pattern.java:1702) at 
> java.util.regex.Pattern.<init>(Pattern.java:1352) at 
> java.util.regex.Pattern.compile(Pattern.java:1028) at 
> org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.runInternal(SparkGetSchemasOperation.scala:76)
>  at org.apache.hive.service.cli.operation.Operation.run(Operation.java:276) 
> at 
> org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.org$apache$spark$sql$hive$thriftserver$SparkOperation$$super$run(SparkGetSchemasOperation.scala:39)
>  at 
> org.apache.spark.sql.hive.thriftserver.SparkOperation.$anonfun$run$1(SparkOperation.scala:44)
>  at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) at 
> org.apache.spark.sql.hive.thriftserver.SparkOperation.withLocalProperties(SparkOperation.scala:78)
>  at 
> org.apache.spark.sql.hive.thriftserver.SparkOperation.withLocalProperties$(SparkOperation.scala:62)
>  at 
> org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.withLocalProperties(SparkGetSchemasOperation.scala:39)
>  at 
> org.apache.spark.sql.hive.thriftserver.SparkOperation.run(SparkOperation.scala:44)
>  at 
> org.apache.spark.sql.hive.thriftserver.SparkOperation.run$(SparkOperation.scala:42)
>  at 
> org.apache.spark.sql.hive.thriftserver.SparkGetSchemasOperation.run(SparkGetSchemasOperation.scala:39)
>  at 
> org.apache.hive.service.cli.session.HiveSessionImpl.getSchemas(HiveSessionImpl.java:535)
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to