[
https://issues.apache.org/jira/browse/SPARK-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14098395#comment-14098395
]
Apache Spark commented on SPARK-3065:
-------------------------------------
User 'luogankun' has created a pull request for this issue:
https://github.com/apache/spark/pull/1968
> Add Locale setting to HiveCompatibilitySuite
> --------------------------------------------
>
> Key: SPARK-3065
> URL: https://issues.apache.org/jira/browse/SPARK-3065
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.0.2
> Environment: CentOS release 6.3 (Final)
> Reporter: luogankun
> Fix For: 1.0.2
>
>
> Run the udf_unix_timestamp of
> org.apache.spark.sql.hive.execution.HiveCompatibilitySuite testcase
> with not "America/Los_Angeles" TimeZone throws：
> [info] - udf_unix_timestamp *** FAILED ***
> [info] Results do not match for udf_unix_timestamp:
> [info] SELECT
> [info] '2009 Mar 20 11:30:01 am',
> [info] unix_timestamp('2009 Mar 20 11:30:01 am', 'yyyy MMM dd h:mm:ss a')
> [info] FROM oneline
> [info] == Logical Plan ==
> [info] Project [2009 Mar 20 11:30:01 am AS
> c_0#25,HiveGenericUdf#org.apache.hadoop.hive.ql.udf.generic.GenericUDFUnixTimeStamp(2009
> Mar 20 11:30:01 am,yyyy MMM dd h:mm:ss a) AS c_1#26L]
> [info] MetastoreRelation default, oneline, None
> [info]
> [info] == Optimized Logical Plan ==
> [info] Project [2009 Mar 20 11:30:01 am AS
> c_0#25,HiveGenericUdf#org.apache.hadoop.hive.ql.udf.generic.GenericUDFUnixTimeStamp(2009
> Mar 20 11:30:01 am,yyyy MMM dd h:mm:ss a) AS c_1#26L]
> [info] MetastoreRelation default, oneline, None
> [info]
> [info] == Physical Plan ==
> [info] Project [2009 Mar 20 11:30:01 am AS
> c_0#25,HiveGenericUdf#org.apache.hadoop.hive.ql.udf.generic.GenericUDFUnixTimeStamp(2009
> Mar 20 11:30:01 am,yyyy MMM dd h:mm:ss a) AS c_1#26L]
> [info] HiveTableScan [], (MetastoreRelation default, oneline, None), None
> [info]
> [info] Code Generation: false
> [info] == RDD ==
> [info] (2) MappedRDD[37] at map at HiveContext.scala:350
> [info] MapPartitionsRDD[36] at mapPartitions at basicOperators.scala:42
> [info] MapPartitionsRDD[35] at mapPartitions at TableReader.scala:112
> [info] MappedRDD[34] at map at TableReader.scala:240
> [info] HadoopRDD[33] at HadoopRDD at TableReader.scala:230
> [info] c_0 c_1
> [info] !== HIVE - 1 row(s) == == CATALYST - 1 row(s) ==
> [info] !2009 Mar 20 11:30:01 am 1237573801 2009 Mar 20 11:30:01 am
> NULL (HiveComparisonTest.scala:367)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
