Cloudera Community
rohit_sureka
user rank
Contributor

Best Practices to access HIVE from IBM SPSS

by Contributor in Support Questions
‎07-25-2016 08:19 AM
‎07-25-2016 08:19 AM
At Daimler , We extensively use IBM SPSS Modeller for Data Science activities and when it comes to access HIVE from IBM SPSS we use Hortonworks ODBC connection. Performance of accessing data is not good and takes huge amount of time. Please suggest the most optimized way to access HIVE data from IBM SPSS and if someone has already done some benchmark that would be highly appreciated. Scenarios : We used small tables with joins IBM SPSS took a lot of time. We tried to combine data on HIVE side and then do filter in IBM SPSS still the performance is not good. Thank you for suggestion and help. ... View more
Labels:

Re: Installing Revo R on HDP 2.3.2

by Contributor in Support Questions
‎05-02-2016 11:04 AM
‎05-02-2016 11:04 AM
Thank you very much @Mats Johansson . ... View more

Installing Revo R on HDP 2.3.2

by Contributor in Support Questions
‎04-06-2016 05:15 AM
‎04-06-2016 05:15 AM
Dear Friends, Does anyone you have been on Revo R with HDP 2.3.2 . We want to integrate existing HDP with Revo R. Any documentation of help is highly appreciated. ... View more

Re: HIVE datatype Timestamp with miliseconds

by Contributor in Support Questions
‎04-04-2016 07:46 AM
‎04-04-2016 07:46 AM
@Predrag Minovic Thank you very much it helps. I checked it again its working. ... View more

Re: HIVE datatype Timestamp with miliseconds

by Contributor in Support Questions
‎04-01-2016 04:53 AM
‎04-01-2016 04:53 AM
@jramakrishnan Yes that's the problem. I also read this document it says it supports miliseconds but when I select the data it chops the miliseconds. ... View more

Re: HIVE datatype Timestamp with miliseconds

by Contributor in Support Questions
‎04-01-2016 03:12 AM
‎04-01-2016 03:12 AM
@jramakrishnan Thank you very much for the answer. However this is not so valid for me as my data in HDFS is already in TimeStamp 'YYYY-MM-DD HH:MM:SS.sss' just that HIVE TimeStamp data type is chopping off the miliseconds part. Regards, Rohit ... View more

HIVE datatype Timestamp with miliseconds

by Contributor in Support Questions
‎03-31-2016 08:11 AM
1 Kudo
‎03-31-2016 08:11 AM
1 Kudo
Hello Friends, I have some data with Timestamp that has mili seconds as '2015-01-16 20:40:00.0' 'YYYY-MM-DD HH:MM:SS.sss' When I chose data type as TimeStamp in HIVE its removing the mili seconds part from the time stamp. Any suggestion is highly appreciated. Thank you, Rohit Sureka ... View more
Labels:

Hbase through YARN

by Contributor in Support Questions
‎03-29-2016 04:42 AM
3 Kudos
‎03-29-2016 04:42 AM
3 Kudos
Hello Friends, Is there a way to interact with Hbase using YARN ( I mean from YARN application) . I want to create a Hbase table insert some rows and delete it. Best Regards, Rohit Sureka ... View more
Labels:

Re: Sqoop to SQL Server with Integrated Security

by Contributor in Support Questions
‎03-29-2016 04:39 AM
2 Kudos
‎03-29-2016 04:39 AM
2 Kudos
Sqoop currently does not support SSO. I got an individual use created and now it works. Thanks ... View more

Re: Sqoop to SQL Server with Integrated Security

by Contributor in Support Questions
‎03-17-2016 03:22 PM
‎03-17-2016 03:22 PM
I am also waiting the same problem with jbdc42.jar and below is the error stack - 16/03/17 15:51:39 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. at org.apache.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:118) at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49) at org.apache.sqoop.Sqoop.run(Sqoop.java:148) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:226) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:235) at org.apache.sqoop.Sqoop.main(Sqoop.java:244) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170) at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2338) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1929) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1917) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1061) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:233) at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:883) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:102) ... 7 more Can some one please help ? ... View more
Contact Me
Online
Offline
Last Visited
‎10-25-2017 08:41 AM
Community Statistics
Member Since ‎03-17-2016 03:20 PM
Last Visited ‎10-25-2017 08:41 AM
Posts 15
Kudos received 6