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
-
FW: Issues with Hive
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
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