About ssubhas

ssubhas · ‎07-21-2016

@payal patel The compression of the table can be validated by checking the definition of the hive table using the command: hive> describe formatted <hive_table>;

ssubhas · ‎07-20-2016

@Rajinder Kaur If you are using Ambari, then you can modify the properties from Ambari and restart affected services. If performing the changes manually, check the owner of the file and modify the file as owner of the file. Regarding configurations, refer to below post with similar issue: https://community.hortonworks.com/questions/5780/hive-on-tez-query-map-output-outofmemoryerror-java.html Hope this helps. Thanks and Regards, Sindhu

ssubhas · ‎07-17-2016

@Hari Rongali This is a current limitation with ACID transactions supported only in ORC format.

ssubhas · ‎07-15-2016

@Nelson KA Rajendran Can you please share the format of the table using command 'show create table test;'? Thanks and Regards, Sindhu

ssubhas · ‎07-15-2016

@Rinku Singh Glad to be of some help. Please mark best answer to end the discussion.

ssubhas · ‎07-14-2016

@Rinku Singh Error: ERROR Datastore.Schema: Failed initialising database. Unable to open a test connection to the given database. JDBC url = jdbc:postgresql://xxxxxxxxxxxxxxxxxxxxxxxx/cirrus1, username = root. Seems like issue with test connectivity. Can you please try testing connectivity using a java program? https://community.hortonworks.com/content/kbentry/25410/simple-steps-to-test-hive-jdbc-connect.html Thanks and Regards, Sindhu

ssubhas · ‎07-13-2016

@arman rahbar The issue can be related to yarn resource manager. Please check the below discussion with same issue: https://community.hortonworks.com/questions/15153/pig-script-status-running-but-always-remain-at-zer.html

ssubhas · ‎07-13-2016

@Rinku Singh Run the below command and share the result: schematool -info -dbType postgres -userName hive -passWord hive -verbose

ssubhas · ‎07-13-2016

@Rinku Singh When you say 56 tables present in MySQL database to postgres database, to which database the tables were migrated to on postgres? What is the jdbc connection URL under hive-site.xml?

ssubhas · ‎07-13-2016

@Rinku Singh From below error, it seems like the Hive metastore is trying to run schemaTool -initSchema: ERROR: relation "BUCKETING_COLS" already exists (state=42P07,code=0) org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !! *** schemaTool failed *** Please run schemaTool -upgradeSchema -dbType <type> -dryRun and let me know the result.

Online	Offline
Last Visited	‎06-08-2020 12:38 PM

Member Since	‎04-11-2016 05:12 AM
Last Visited	‎06-08-2020 12:38 PM
Posts	535
Kudos received	147

Cloudera Community

Re: What does --m 1 represent in sqoop import sta...

Re: HDP-2.6.4.0 - Superset startup failes with err...

Re: Unable to import data from Informix non transa...

Re: We have an AWS cluster setup for HCP Metron a...

Re: HDP support for Sqoop 2.x ?

Re: How to validate which compression technique ha...

Re: Java. Lang. OutOfMemoryError

Re: Why Hive supports ACID properties in ORC File ...

Re: Hive string to int data type conversion with t...

Re: Migrate Hive Metastore from MySQL to Postgres

Re: Migrate Hive Metastore from MySQL to Postgres

Re: pig execution does not have progress.

Re: Migrate Hive Metastore from MySQL to Postgres

Re: Migrate Hive Metastore from MySQL to Postgres

Re: Migrate Hive Metastore from MySQL to Postgres