@Artem Ervits - I was able to find all the settings under hive service . Thanks! ... View more

@Artem Ervits - Thanks. I'd like to update hive-site.xml with the following statements. Where can I find hive-site.xml within the hortonworks web interface? hive.support.concurrency – true hive.enforce.bucketing – true (Not required as of Hive 2.0) hive.exec.dynamic.partition.mode – nonstrict hive.txn.manager – org.apache.hadoop.hive.ql.lockmgr.DbTxnManager hive.compactor.initiator.on – true (for exactly one instance of the Thrift metastore service) hive.compactor.worker.threads – a positive number on at least one instance of the Thrift metastore service ... View more

@Artem Ervits -- do you have any suggestion to overcome this error? I'm unable to make updates to the following table:update-error.png ... View more

ok @Artem Ervits -- i just posted a question for this. ... View more

Thanks in advance for your time and suggestions. ... View more

@Artem Ervits -- How can I set primary key and reference foreign keys while creating a table / extrenal table in hive? I'm getting the following error: external-table-error.png ... View more

@Artem Ervits - I was able to execute the query for external table creation.. thanks:) ... View more

@Ancil McBarnett & @Artem Ervits -- Thanks a lot for taking the time to reply. I tried creating an external table to point to the hdfs location I'm getting the following error (please find the image below). Besides, I entered these lines randomly .. FIELDS TERMINATED BY '\t' STORED AS TEXTFILE. I'm not sure if it's tab separated nor saved as a text file. How can I view the mysql tables imported into hive or hdfs?? I'm unable to open it. error.png ... View more

@Artem Ervits -- Thanks. Any suggestions how I can do it? because I was unable to read from this location with the code I wrote. ... View more