2 Replies Latest reply on Aug 20, 2013 5:20 AM by Amarendu Samal

    Problem with date Datatype when connecting Tableau with Apache Hadoop through Hive

    Amarendu Samal

      Hi,

       

      Got stuck with Date  when using data present in HDFS . The same data when used as normal text file works fine and Tableau could easily detect the data type and also works fine with PostgreSQL..

       

      When I used the same data through HDFS (Hadoop) there was a problem with datatype .

       

      Here is an example of data that i am using

       

      *****32|0*****2|8/2/91|NA|N/A

      *****04|1*****2|10/15/94|31|LEFT

      *****04|NA|10/17/94|31|LEFT

      *****59|1*****82|10/3/94|30|FOLLOW

      *****34|1*****32|5/14/92|47|N/A

      *****47|1*****92|2/6/95|54|COUGH

      *****02|*****31|9/15/94|NA|SCHNIA

      *****28|*****02|8/1/94|46|C/O H

      *****17|*****91|12/9/94|NA|CRYPT

      *****17|*****12|1/11/95|NA|EVER

       

      When using this piece of data in HDFS as String it is showing the data as it is. When Changing the datatype to date it gets converted into null value.

      Since I am using this field as filter no values are shown as filter.

       

      But when the same data piece is as normal txt file or through it works fine.

      I even  tried to change the datatype to TIMESTAMP as used in Hadoop but it stops showing error.

       

      Please help.

       

      Regards

      Amarendu