Hello, I have a smalldatetime data in my database server sql data and when I matter with Sqoop , this data is stored in the Hive String format because smalldatetime does not exist in the hive tool. This becomes probmématique for my work. Anyone know if there a way to import through Sqoop , smallldatetime a data type of sql server and store the timestamp format recognized by Hive . thanks ... View more

Hello I work with Hive- Context to load and manipulate data in my orc format. I would now please know how to save in the hdfs file the results of a sql queries ? Help me please? Here is my Hive-Context code, I would like to save the contents of hive_context in a file on my hdfs : Thanks you in advance from pyspark.sql import HiveContext from pyspark import SparkContext sc =SparkContext() hive_context = HiveContext(sc) qvol = hive_context.table("<bdd_name>.<table_name>") qvol.registerTempTable("qvol_temp") hive_context.sql("select * from qvol_temp limit 10").show() ... View more

I created a query view with hive in Hue and I would like to modify its definition without deleting . Can you help me please ... View more