Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Issues with Hive


Copy link to this message
-
Issues with Hive
Hi,

I am writing a hive query to run on over 800 columns, what I am doing is a count(distinct(col_name)) of all the columns in one hive query with a select query. I got the following error.
I am trying to save up time on running map reduce jobs , earlier I was running separate map reduce jobs for each variable.
java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row {"rhive_row":"1138","f16":43,"f17":"S","f18":43,"f19":null,"f20":"","f21":0,"f22":"H","f23":null,"f24":"","f25":3,"f26":"F","f27":"01","f28":null,"f29":null,"f30":null,"f31":null,"f32":null,"f33":null,"f34":"","f35":null,"f36":null,"f37":null,"f38":"","f39":"","f40":null,"f41":null,"f42":null,"f43":"","f44":null,"f45":null,"f46":"","f47":"","f48":"","f49":null,"f50":null,"f51":null,"f52":null,"f53":null,"f54":null,"f55":null,"f56":null,"f57":null,"f58":null,"f59":null,"f60":null,"f61":null,"f62":null,"f63":"","f64":"","f65":"","f66":null,"f67":null,"f68":null,"f69":null,"f70":null,"f71":"","f72":null,"f73":null,"f74":"","f75":"","f76":"","f77":null,"f78":null,"f79":"","f80":null,"f81":null,"f82":null,"f83":"","f84":null,"f85":"","f86":null,"f87":null,"f88":null,"f89":"","f90":null,"f91":null,"f92":null,"f93":null,"f94":null,"f95":null,"f96":null,"f97":null,"f98":null,"f99":null,"f100":null,"f101":"","f102":"","f103":null,"f104":null,"f105":null,"f106":null,"f107":"","f108":"","f109":null,"f110":"","f111":"","f112":"","f113":null,"f114":null,"f115":null,"f116":null,"f117":"","f118":null,"f119":"","f120":null,"f121":null,"f122":null,"f123":null,"f124":null,"f125":null,"f126":null,"f127":null,"f128":null,"f129":null,"f130":null,"f131":"","f132":null,"f133":null,"f134":null,"f135":null,"f136":null,"f137":"","f138":"","f139":null,"f140":"","f141":null,"f142":"","f143":null,"f144":"","f145":null,"f146":null,"f147":null,"f148":null,"f149":null,"f150":null,"f151":null,"f152":null,"f153":null,"f154":null,"f155":null,"f156":null,"f157":null,"f158":null,"f159":null,"f160":"","f161":"","f162":null,"f163":"","f164":null,"f165":"","f166":null,"f167":null,"f168":"","f169":null,"f170":null,"f171":"","f172":"","f173":"","f174":null,"f175":null,"f176":"","f177":null,"f178":null,"f179":null,"f180":null,"f181":null,"f182":"","f183":"","f184":null,"f185":null,"f186":null,"f187":null,"f188":"","f189":"","f190":"","f191":"","f192":"","f193":null,"f194":"","f195":null,"f196":null,"f197":null,"f198":null,"f199":"","f200":null,"f201":"","f202":null,"f203":"","f204":"","f205":"","f206":null,"f207":null,"f208":"","f209":null,"f210":null,"f211":null,"f212":"","f213":null,"f214":"","f215":null,"f216":null,"f217":null,"f218":null,"f219":null,"f220":null,"f221":null,"f222":null,"f223":null,"f224":null,"f225":null,"f226":"","f227":null,"f228":null,"f229":"","f230":null,"f231":"","f232":"","f233":null,"f234":"","f235":null,"f236":"","f237":null,"f238":"","f239":"","f240":"","f241":null,"f242":null,"f243":"","f244":"","f245":"","f246":null,"f247":"","f248":"","f249":null,"f250":"","f251":null,"f252":"","f253":"","f254":null,"f255":"","f256":"","f257":null,"f258":"","f259":"","f260":null,"f261":"","f262":"","f263":"","f264":null,"f265":"","f266":null,"f267":null,"f268":"","f269":"","f270":"","f271":"","f272":"","f273":null,"f274":null,"f275":"","f276":null,"f277":"","f278":"","f279":null,"f280":"","f281":"","f282":"","f283":null,"f284":null,"f285":"","f286":"","f287":null,"f288":null,"f289":"","f290":"","f291":"","f292":null,"f293":"","f294":null,"f295":"","f296":null,"f297":"","f298":null,"f299":null,"f300":null,"f301":null,"f302":null,"f303":null,"f304":null,"f305":null,"f306":null,"f307":null,"f308":null,"f309":null,"f310":null,"f311":null,"f312":null,"f313":null,"f314":null,"f315":null,"f316":null,"f317":null,"f318":null,"f319":null,"f320":null,"f321":null,"f322":null,"f323":null,"f324":null,"f325":null,"f326":null,"f327":null,"f328":null,"f329":null,"f330":null,"f331":null,"f332":null,"f333":null,"f334":null,"f335":null,"f336":null,"f337":null,"f338":null,"f339":null,"f340":null,"f341":null,"f342":null,"f343":null,"f344":null,"f345":null,"f346":null,"f347":null,"f348":null,"f349":null,"f350":null,"f351":null,"f352":null,"f353":null,"f354":null,"f355":null,"f356":null,"f357":null,"f358":null,"f359":null,"f360":null,"f361":null,"f362":null,"f363":null,"f364":null,"f365":null,"f366":null,"f367":null,"f368":null,"f369":null,"f370":null,"f371":null,"f372":null,"f373":null,"f374":null,"f375":null,"f376":null,"f377":null,"f378":null,"f379":null,"f380":null,"f381":null,"f382":null,"f383":null,"f384":null,"f385":null,"f386":null,"f387":null,"f388":null,"f389":null,"f390":null,"f391":null,"f392":null,"f393":"","f394":"","f395":null,"f396":"","f397":null,"f398":null,"f399":null,"f400":"","f401":"","f402":null,"f403":null,"f404":null,"f405":null,"f406":null,"f407":null,"f408":null,"f409":"S","f410":"N","f411":"","f412":"K","f413":0,"f414":350,"f415":"N","f416":"N","f417":null,"f418":"N","f419":"","f420":7,"f421":1940,"f422":null,"f423":0,"f424":0,"f425":null,"f426":"","f427":1,"f428":2,"f429":"1920-09-07","f430":0,"f431":3,"f432":6,"f433":null,"f434":0,"f435":"","f436":"","f437":"N","f438":5,"f439":1,"f440":0,"f441":"","f442":"E","f443":5,"f444":1,"f445":2,"f446":80,"f447":null,"f448":"I","f449":"N","f450":"A","f451":"","f452":"N","f453":null,"f454":"Y","f455":14,"f456":"","f457":"","f458":0,"f459":null,"f460":5,"f461":9,"f462":2,"f463":2,"f464":1,"f465":"","f466":0,"f467":0,"f468":0,"f469":0,"f470":0,"f471":0,"f472":4,"f473":5,"f474":1,"f475":1,"f476":0,"f477":0,"f478":0,"f479":0,"f480":19,"f481":0,"f482":2,"f483":0,"f484":0,"f485":52,"f486":627092,"f487":4,"f488":14,"f489":4,"f490":3,"f491":7,"f492":520,"f493":3,"f494":704678,"f495":74,"f496":281,"f497":520,"f498":0,"f499":390,"f500":945,"f501":2,"f502":3,"f503":2,"f504":107966,"f505":6,"f506":5,"f507":0,"f508":0,"f509":0,"f510":0,"f511":0,"f512":0,"f513":0,"f514":0,"f515":0,"f516":0,"f517":0,"f518":0,"f519":0,"f520":0,"f521":0,"f522":0,"f523":0,"f524"
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB