[
https://issues.apache.org/jira/browse/CARBONDATA-4047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17258005#comment-17258005
]
Akash R Nilugal commented on CARBONDATA-4047:
---------------------------------------------
Also join our slack channel, you can directly ask questions there instead of
raising issues directly as it will delay for responses.
https://join.slack.com/t/carbondataworkspace/shared_invite/zt-g8sv1g92-pr3GTvjrW5H9DVvNl6H2dg
> Datediff datatype is not working with spark-2.4.5. even in spark-sql its
> showing as null. .Either the query might be wrong or the versions don't
> support datatypes.
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: CARBONDATA-4047
> URL: https://issues.apache.org/jira/browse/CARBONDATA-4047
> Project: CarbonData
> Issue Type: Task
> Components: spark-integration
> Affects Versions: 2.0.0
> Environment: Hadoop - 3.2.1
> Hive - 3.1.2
> Spark - 2.4.5
> carbon data-2.0
> mysql connector jar - mysql-connector-java-8.0.19.jar
> Reporter: sravya
> Priority: Major
> Labels: CarbonData, hadoop, hive, spark2.4
> Attachments: carbon error.PNG, sparksql.PNG
>
>
> 1.scala> carbon.sql("CREATE TABLE IF NOT EXISTS vestedlogs3 as (select * ,
> intck ("Hours", 'StartTimestamp', 'CompleteTimestamp') as Hours FROM
> vestedlogs) STORED AS carbondata").show()
> <console>:1: error: ')' expected but string literal found.
> carbon.sql("CREATE TABLE IF NOT EXISTS vestedlogs3 as (select * , intck
> ("Hours", 'StartTimestamp', 'CompleteTimestamp') as Hours FROM vestedlogs)
> STORED AS carbondata").show()
>
> 2.scala> carbon.sql("CREATE TABLE IF NOT EXISTS vestedlogs3 (SELECT
> *,DATEDIFF(HOUR,StartTimestamp GETDATE(),CompleteTimestamp GETDATE() AS
> "Hours" FROM vestedlogs) STORED AS carbondata").show()
> <console>:1: error: ')' expected but string literal found.
> carbon.sql("CREATE TABLE IF NOT EXISTS vestedlogs3 (SELECT
> *,DATEDIFF(HOUR,StartTimestamp GETDATE(),CompleteTimestamp GETDATE() AS
> "Hours" FROM vestedlogs) STORED AS carbondata").show()
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
