java - Hive Table is Empty check -


how can check if particular table table empty in hive.i need store boolean value variable in java code.i tried 

statement stmt = con.createstatement();      stmt.execute("select count(*) "+tablename);     int ct = stmt.getupdatecount();     logger.info("hive table count " +ct);     if(ct > 0)       return false;     else      return true;

but doesnot seem work. suggestions ?

try this:

    statement stmt = con.createstatement();     resultset rs = stmt.executequery("select count(*) "+tablename);     int ct = rs.getint(0);     logger.info("hive table count " +ct);     if(ct > 0)       return false;     else      return true;

Comments

Post a Comment

Popular posts from this blog

Why can rails not find a route created by a helper? -

i created member route in rails 4: resources :line_items post 'decrement', on: :member end and gave matching method in line_items controller: def decrement @cart = current_cart @line_item = @cart.line_items.find_by_id(params[:id]) @line_item.decrement_quantity respond_to |format| if @line_item.save format.html { redirect_to shop_path, notice: 'line item updated.' } format.js {@current_item = @line_item} format.json { head :ok } else format.html { render action: "edit" } format.js {@current_item = @line_item} format.json { render json: @line_item.errors, status: :unprocessable_entity } end end end but when try make button: <%= button_to 'x', decrement_line_item_path(item) %> i error: no route matches [post] "/carts/25" what gives? your error message is: no route matches [post] "/carts/25" but expectin...
Read more

javascript - jquery or ashx not working -

i using ajax file upload control. it creating html: <form action="/pages/handlers/asyncfileuploadhandler.ashx" method="post" enctype="multipart/form-data" target="ajaxuploader-iframe-1397144545"> <input type="hidden" name="type" value="mindvoice"> <input type="file" id="imagefile" style="display: block; width: 80%; margin-right: auto; margin-left: auto;"> </form> and target is: <iframe width="0" height="0" style="display:none;" name="ajaxuploader-iframe-1397144545" id="ajaxuploader-iframe-1397144545"></iframe> the form submitted using .submit() . my ashx handler: <%@ webhandler language="c#" class="asyncfileuploadhandler" %> using system; using system.web; using nettpals.core; public class asyncfileuploadhandler : ihttphandler { public void processre...
Read more

php - Redirect and hide target URL -

i want implement website youtube, these real urls of videos has hidden. when user comes in, , php webpage authenticate user, , redirect user real url of video. problem how can redirect url , hide real video url, or other ways prevent real url of videos exposed? i don't know if got point, looking this? $video_url = $user_is_authenticated ? $video_url : $authentication_url."?returnurl=".$video_url; echo "<a href='$video_url'>video title</a>"; this way, if user authenticated, send him real video url, otherwise login page seen instead. if don't want users see url can use session variables during authentication.
Read more