Hyukjin Kwon created SPARK-20018:
------------------------------------

             Summary: Pivot with timestamp and count should not print internal 
representation
                 Key: SPARK-20018
                 URL: https://issues.apache.org/jira/browse/SPARK-20018
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.2.0
            Reporter: Hyukjin Kwon
            Priority: Minor


Currently, when we perform count with timestamp types, it prints the internal 
representation as the column name as below:

{code}
scala> Seq(new 
java.sql.Timestamp(1)).toDF("a").groupBy("a").pivot("a").count().show()
+--------------------+----+
|                   a|1000|
+--------------------+----+
|1969-12-31 16:00:...|   1|
+--------------------+----+
{code}

It seems this should be 

{code}
Testing started at PM 10:30 ...
+--------------------+-----------------------+
|                   a|1969-12-31 16:00:00.001|
+--------------------+-----------------------+
|1969-12-31 16:00:...|                      1|
+--------------------+-----------------------+
{code}




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to