About nsabharwal

nsabharwal · ‎11-18-2015

@bsaini Link DML is not the option

nsabharwal · ‎11-18-2015

@bsaini It should work but migration from Access DB to Hive is in the question

nsabharwal · ‎11-18-2015

@bpreachuk I am not sure if there is direct path from Access to Hive. I have done Access to RDBMS then eventually Hive.

nsabharwal · ‎11-18-2015

@Peter Coates This was brought by couple of DS guys. We discussed using Spark link

nsabharwal · ‎11-18-2015

@Artem Ervits @mlanciaux Sql Developer

nsabharwal · ‎11-18-2015

@mlanciaux DBVisualizer or Squirrel. Please see this http://community.hortonworks.com/content/kbentry/3043/connecting-to-hive-thrift-server-on-hortonworks-us.html

nsabharwal · ‎11-18-2015

@Ravi Please see this jira https://issues.apache.org/jira/browse/HADOOP-8069 and I believe this explains it <name>ipc.server.tcpnodelay</name> <value>true</value> <description>Turn on/off Nagle's algorithm for the TCP socket connection on the server. Setting to true disables the algorithm and may decrease latency with a cost of more/smaller packets.

nsabharwal · ‎11-18-2015

@Andrew Watson Please see this. Doc This can be related HiveBUG-37429HIVE-9937vectorization with ACID table, count(1) fails with ArrayIndexOutOfBounds Exception

nsabharwal · ‎11-18-2015

@hrongali I am following stackoverflow link. Can you try this? sqoop import --verbose --driver com.sybase.jdbc4.jdbc.SybDriver --connect jdbc:sybase:Tds:dbgbl-tst:8032/DATABASE=trim_bw --query "select * from trim_bw..account where \$CONDITIONS" --fields-terminated-by ',' --username hrongali -P --hive-database trim_bw --hive-table account --hive-import -m 1

nsabharwal · ‎11-18-2015

@terry Did you update the pid manually?

Online	Offline
Last Visited	‎07-18-2019 05:10 PM

Member Since	‎09-18-2015 05:49 PM
Last Visited	‎07-18-2019 05:10 PM
Posts	3,274
Kudos received	1129

Cloudera Community

Re: Is Ranger KMS Encryption FIPS 140-2 compliant ...

Re: How to add another HiveServer for current meta...

Re: FQDNs - are they necessary?

Re: java.io.FileNotFoundException: (Is a director...

Re: Need Design/Architecture Suggestion on HDP & H...

Re: Can Microsoft/Hortonworks ODBC Driver provide ...

Re: Can Microsoft/Hortonworks ODBC Driver provide ...

Re: Can Microsoft/Hortonworks ODBC Driver provide ...

Re: What's the best way to do Monte Carlo simulati...

Re: Hive GUI !

Re: Hive GUI !

Re: What services need to be restarted if ipc.ser...

Re: Vectorization Causing a Select COUNT(1) Query ...

Re: Sqoop import from Sybase to Hive failing when ...

Re: Ambari shows the Zookeeper quorum as down but ...