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 <[email protected]> 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 <[email protected]> > 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/[email protected]/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. > > > >
