Trying to create an extrenal table in Hive for MongoDBthrows error

2018-08-26 Thread Mich Talebzadeh
Hi, Trying to create an external table in Hive to be accessed by MongoDB. This is the code in Hive ADD JAR /home/hduser/jars/mongo-hadoop-core-2.0.2.jar; ADD JAR /home/hduser/jars/mongo-hadoop-hive-2.0.2.jar; ADD JAR /home/hduser/jars/mongo-java-driver-3.8.1.jar; use accounts; DROP TABLE IF

Re: Improve performance of Analyze table compute statistics

2018-08-26 Thread Jörn Franke
You can partition it and only compute statistics for new partitions... > On 26. Aug 2018, at 12:43, Prabhakar Reddy wrote: > > Hello, > > Are there any properties that I can set to improve the performance of Analyze > table compute statistics statement.My data sits in s3 and I see it's taking

Improve performance of Analyze table compute statistics

2018-08-26 Thread Prabhakar Reddy
Hello, Are there any properties that I can set to improve the performance of Analyze table compute statistics statement.My data sits in s3 and I see it's taking one second per file to read the schema of each file from s3. 2018-08-24T03:25:57,525 INFO [2b2c0a06-7da5-4fcd-83a7-4931b8e1b4b1