Hello,   I'm having a script file that I want to run with impala-shell.  When I do :   hadoop dfs -ls  /user/developer/scripts/Impala/    I can see my file   However, when I try to do it in impala I get no such file or directory.    impala-shell -f /user/developer/scripts/Impala/myFile   What should I check? Why is impala not finding my file?   Thank you! ... View more

Hello,   By doing these 2 queries I get the same result (1412640000): select unix_timestamp('2014-10-07 00:00:00.209','yyyy-MM-dd HH:mm:ss.SSS') as date_event from myTable; select unix_timestamp('2014-10-07 00:00:00.100','yyyy-MM-dd HH:mm:ss.SSS') as date_event from myTable;   However, by doing I get 1412640001 select unix_timestamp('2014-10-07 00:00:01.100','yyyy-MM-dd HH:mm:ss.SSS') as date_event from myTable; the timestamp changes well;     I have the feeling that the seconds are not taken into account,   My Impalad version is 2.1.0-cdh5 (build e48c2b48c53ea9601b8f47a39373aa83ff7ca6e2)   Thank you! ... View more

Hello,   I created a json table in Hive and then I loaded data from a folder into it. The query is sucessful.  ADD JAR /data/hive/jars/json-serde-1.3-jar-with-dependencies.jar; Select * from myTable  However, when I try to access the table I get an error: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer When I try to access the same table with the same query in Hive shell I do not get any error and I can acess the table.   Where should I look for? IS there any other jar that I have to add in order to make this work in beeswax(hue)?    Thank you! ... View more

Hello, I'm searching for a good tutorial about how to schedule impala jobs into oozie.   The only threads that I found about this subject are:   o https://issues.apache.org/jira/browse/OOZIE-1591 o https://groups.google.com/a/cloudera.org/forum/#!topic/impala-user/8vM7fKR7F3A     Can you please help? (give at least one example) ... View more

Hello,   I need to compare a date with today date so I want to use the function unix_timestamp().  However this function returns one (1970-01-01 00:00:01).   Note: - The servers date is correctly setted up.  - I use an AWS infrastructure   What else should I check in order to make this function work?   thank you! ... View more

Hello,   I would like to know: 1- if it is normal that I don't see the impala jobs in the job browser (the hive/pig... jobs I can see there). 2- what is the best way to create an oozie action for impala:              - note I saw that                       - this thread is still open https://issues.apache.org/jira/browse/OOZIE-1591                        - and I saw that I could create an impala shell action https://groups.google.com/a/cloudera.org/forum/#!topic/impala-user/8vM7fKR7F3A       Thank you!     ... View more