Mich, Try changing the hadoop.version in Hive's pom.xml to 2.7.3 and re-build. That should at least let you know where the problem are.
.. Owen On Fri, Jun 8, 2018 at 9:05 AM, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > Hi Owen, > > It is 2.7.3 > > hadoop version > Hadoop 2.7.3 > Subversion https://git-wip-us.apache.org/repos/asf/hadoop.git -r > baa91f7c6bc9cb92be5982de4719c1c8af91ccff > Compiled by root on 2016-08-18T01:41Z > > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > *Disclaimer:* Use it at your own risk. Any and all responsibility for any > loss, damage or destruction of data or any other property which may arise > from relying on this email's technical content is explicitly disclaimed. > The author will in no case be liable for any monetary damages arising from > such loss, damage or destruction. > > > > On 8 June 2018 at 16:59, Owen O'Malley <owen.omal...@gmail.com> wrote: > >> This looks like there is an API incompatibility between the version of >> hadoop expected and the version used. Which version of hadoop are you using? >> >> .. Owen >> >> On Jun 8, 2018, at 08:31, Mich Talebzadeh <mich.talebza...@gmail.com> >> wrote: >> >> Just installed and upgraded to Hive 3 where fun and game started :) >> >> First I had to set below as per this JIRA >> <https://www.mail-archive.com/issues@hive.apache.org/msg121026.html> to >> make hive server 2 start and stay up >> >> setting hive.metastore.event.db.notification.api.auth to false on >> hive-site.xml >> >> Now when I connect via beeline I see this error >> >> >> *0: jdbc:hive2://rhes75:10099/default> select * from sales limit 10;* >> Error: java.io.IOException: java.lang.RuntimeException: ORC split >> generation failed with exception: java.lang.NoSuchMethodError: >> org.apache.hadoop.fs.FileStatus.compareTo(Lorg/apache/hadoop/fs/FileStatus;)I >> (state=,code=0) >> >> Table is an ORC table as follows and used to work fine >> >> 0: jdbc:hive2://rhes75:10099/default> desc formatted sales; >> +-------------------------------+--------------------------- >> -------------------------+----------------------------------------------+ >> | col_name | >> data_type | >> comment | >> +-------------------------------+--------------------------- >> -------------------------+----------------------------------------------+ >> | # col_name | data_type >> | comment | >> | prod_id | bigint >> | | >> | cust_id | bigint >> | | >> | time_id | timestamp >> | | >> | channel_id | bigint >> | | >> | promo_id | bigint >> | | >> | quantity_sold | decimal(10,0) >> | | >> | amount_sold | decimal(10,0) >> | | >> | | NULL >> | NULL | >> | # Partition Information | NULL >> | NULL | >> | # col_name | data_type >> | comment | >> | year | int >> | | >> | month | int >> | | >> | | NULL >> | NULL | >> | # Detailed Table Information | NULL >> | NULL | >> | Database: | oraclehadoop >> | NULL | >> | OwnerType: | USER >> | NULL | >> | Owner: | hduser >> | NULL | >> | CreateTime: | Wed May 31 16:31:47 BST >> 2017 | NULL >> | >> | LastAccessTime: | UNKNOWN >> | NULL | >> | Retention: | 0 >> | NULL | >> | Location: | >> hdfs://rhes75:9000/user/hive/warehouse/oraclehadoop.db/sales >> | NULL | >> | Table Type: | MANAGED_TABLE >> | NULL | >> | Table Parameters: | NULL >> | NULL | >> | | COLUMN_STATS_ACCURATE >> | {\"BASIC_STATS\":\"true\"} | >> | | numFiles >> | 12544 | >> | | numPartitions >> | 49 | >> | | numRows >> | 917359 | >> | | orc.bloom.filter.columns >> | PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID | >> | | orc.bloom.filter.fpp >> | 0.05 | >> | | orc.compress >> | SNAPPY | >> | | orc.create.index >> | true | >> | | orc.row.index.stride >> | 10000 | >> | | orc.stripe.size >> | 268435456 | >> | | rawDataSize >> | 271538264 | >> | | totalSize >> | 77602053 | >> | | transient_lastDdlTime >> | 1496244707 | >> | | NULL >> | NULL | >> | # Storage Information | NULL >> | NULL | >> | SerDe Library: | org.apache.hadoop.hive.ql.io.orc.OrcSerde >> | NULL | >> | InputFormat: | >> org.apache.hadoop.hive.ql.io.orc.OrcInputFormat >> | NULL | >> | OutputFormat: | >> org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat >> | NULL | >> | Compressed: | No >> | NULL | >> | Num Buckets: | 256 >> | NULL | >> | Bucket Columns: | [prod_id, cust_id, time_id, channel_id, >> promo_id] | NULL | >> | Sort Columns: | [] >> | NULL | >> | Storage Desc Params: | NULL >> | NULL | >> | | serialization.format >> | 1 | >> +-------------------------------+--------------------------- >> -------------------------+----------------------------------------------+ >> 48 rows selected (0.561 seconds) >> >> >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn * >> https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> *Disclaimer:* Use it at your own risk. Any and all responsibility for >> any loss, damage or destruction of data or any other property which may >> arise from relying on this email's technical content is explicitly >> disclaimed. The author will in no case be liable for any monetary damages >> arising from such loss, damage or destruction. >> >> >> >> >
