Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Issues with Hive


Copy link to this message
-
FW: Issues with Hive
Mayank Bansal 2012-06-12, 14:04
Hi,

Regarding the error below I was doing a hit and trial method of work.
I found that I could run a maximum of 128 count(distinct()) in a single select query in Hive.
I wanted to ask is this correct or is there something wrong with my system.
If this is correct, can this value be changed by the user ?

Thanks,
Mayank

From: Mayank Bansal
Sent: Monday, June 11, 2012 7:29 PM
To: '[EMAIL PROTECTED]'
Subject: 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