Re: May I ask a question about SparkSql

2016-04-08 Thread Kasinathan, Prabhu
Check this one. https://github.com/Intel-bigdata/spark-streamingsql. We tried it and it was working with Spark 1.3.1. You can do ETL on Spark Streaming Context using Spark Sql. Thanks Prabhu From: Hustjackie > Reply-To:

Re: Converting a string of format of 'dd/MM/yyyy' in Spark sql

2016-03-24 Thread Kasinathan, Prabhu
Can you try this one? spark-sql> select paymentdate, TO_DATE(FROM_UNIXTIME(UNIX_TIMESTAMP(paymentdate,'MM/dd/'),'-MM-dd')) from tmp; 10/02/2014 2014-10-02 spark-sql> From: Tamas Szuromi > Date: Thursday, March