Hi @Dinesh Das You might have better luck passing in the actual TRUNCATE TABLE statement in your sqoop eval using the --query option instead of trying to --call the stored procedure (I think those are only supported in sqoop export, not sqoop eval, but I could be mistaken). As always, if you find this post useful please "accept" the answer. ... View more

Hi @Sami Ahmad Try postgresql-server https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-centos-7 As always, if you find this post useful please "accept" the answer. ... View more

Hi @BiswaRanaj Samal Looks like the link has been moved. You can still fetch the file here: https://github.com/hortonworks/data-tutorials/blob/master/tutorials/hdf/analyze-traffic-pattern-with-apache-nifi/assets/trafficLocs_data_for_simulator.zip As always, if you find this post useful please "accept" the answer. ... View more

hi @Dinesh Das If you load your data as a String initially into a staging table, you can use the unix_timestamp() function to get easy date formatting: select from_unixtime(unix_timestamp(origDateColumn ,'yyyyMMddhhmmss'), 'yyyyMMdd') from StagingTable Alternatively, you can create a custom UDF to handle it for you. As always, if you find this post useful, please "Accept" the answer. ... View more

Hi @Ali Mahinpoor See this post that might help: https://community.hortonworks.com/questions/47594/how-can-i-upload-ocr-files-to-hive.html As always if you find this post useful, please "Accept" the answer. ... View more

Hi @Dinesh Das You can do a CREATE EXTERNAL table as normal, but add the storage qualifier to it. For example: create external table countries_ext_seq LIKE countries_seq STORED AS SEQUENCEFILE LOCATION '/tmp/seqTest' In the above example, I already have an existing hive table with the same columns and datatypes, so I use the lazy method by using the LIKE clause, but you can do the same with a full definition. I'm able to create this external table, point it to an existing sequence file stored in HDFS, and query with no problem. As always, if you find this post useful, please "Accept" the answer. ... View more