The Hortonworks Community Connection is now live. A completely rebuilt Q&A forum, Knowledge Base, Code Hub and more, backed by the experts in the industry.

You will be redirected here in 10 seconds. If your are not redirected, click here to visit the new site.

The legacy Hortonworks Forum is now closed. You can view a read-only version of the former site by clicking here. The site will be taken offline on January 31,2016

Hive / HCatalog Forum

Table stats shows num_rows: 0 Hive v0. (from HDP 1.32)

  • #36844
    Tri Nguyen


    This may be a bug in Hive v0. (from HDP 1.32). Can you please confirm?

    When an empty table is populated, the tables stats (appeared in the Hive console output) always indicates num_rows: 0
    Table default.test1 stats: [num_partitions: 0, num_files: 1, num_rows: 0, total_size: 6203, raw_data_size: 0]

    Please note that this issue doesn’t exist in the Sandbox 1.3RC6. The table stats indicated the correct value for num_rows.

    Example of syntax:

    COMMENT ‘Demonstrate Hive Table stats always shows num_rows: 0 when the table is populated (either by CREATE TABLE … AS SELECT … or by INSERT OVERWRITRE TABLE’
    SELECT Col1, Col2, Col3
    FROM MyDemoTable;


    SELECT Col1, Col2, Col3
    FROM MyDemoTable;

    Thanks in advance for any help.

  • Author
  • #36986 – cheap ugg boots uk Speaking Sunday, that official cautioned the schedule was subject to change This is a much better tip for those that desire a bag for their personal usage instead than those purchasing for resale because out of season bags could not offer as quickly as you wish they wouldHome Instead has lobbied especially hard to keep the labor exemption on overtimethis was the in cyclingWe moderate comments “With retail participation up 20%, strong international media attendance, partnered with a dynamic show floor environment, E3 Expo has affirmed its status as the cornerstone event for our global video game business – Cheap NFL Nike Jerseys Although we cannot tangibly measure the fourth dimension whether by tools or our own senses we can certainly think about it, as evident in this week’s additional reading by Linda Henderson It called the transformer dress which basically is a dress that comes in many different colors but if you twist some parts of it differently it creates a brand new design The stationary bezel is encrusted in the very best Swarovski crystals for a great offset to the black and white options of the dial providing this see a minor bling variable To watch the Liberals defeat their own private member’s Bill by abstaining in numbers large enough to make sure it dies is frightening”I remember before the start of the ‘0102 season, Jason got up and told us at a dinner before training camp that ‘the losing was over,”‘ said Mitch Kaufman, the longtime Nets’ director of video operations said – uggs kopen The body of a woman should be assessed well enough to be able to find a dress that wou All of the action isn’t just in bootsHeisenberg cheeky dialogue tickled many of the judges You talk to any investor in Europe and US and they won’t touch the market if inflation is that high Burberry Designer HandbagsBurberry designer handbags are the ultimate accessory for any outfit, and They can be used as fashion accessories $140 at Ice boutiques in Toronto (4169646751) and Vancouver (6046827467)By dusk in Paris, the luxury shopping district was awash with thousands of people out to see spectacles like the one at Chloe, where a parade of dancing cheerleaders descended from a Chevrolet truck – Wholesale NFL Jerseys Hey, sorry Yet, trying to apply reason in its conventional sense to Chouinard 75minute work is a surefire route to frustration I think that the way you have to play itWhen you watch him on screen, you never know whether things will remain calm, as they do in his dramatic roles in “Hope Springs” (where he plays counselor to Meryl Streep and Tommy Lee Jones’ passionseeking married couple) and in “Little Miss Sunshine” (his suicidal, gay Proust expert anchoring some dysfunctional family comedy), or go kablooey, as they do when he’s a newscaster suddenly spouting gibberish (“Bruce Almighty,” from 2003) or an office manager who can’t help doing or saying the absolute wrong thing at the worst time (NBC’s “The Office,” which he left in 2011)POSTING POLICY: Vulgar, obscene, and offensive language will not be tolerated Your use of the site indicates your agreement to be bound by the Terms of Use – cheap uggs that oxygen administration was a safe and effective treatment for migraine or cluster headaches,” said lead reviewer Michael or read their obituary at Philadelphia Inquirer Philadelphia Daily NewsHi Mike I know its sp bad I didnt write to u in so long but been busy working and taking care of the lil one”Rearview camera systems are available on 7 in 10 new vehicles, as either standard equipment or an option,” said Wade Newton of the Auto Alliance [HuffPo – Here is a Hungarian coffee house with livein catsFloyd County Prosecutor Keith Henderson said the grand jury met for five days and heard from 17 witnesses before determining this week that the deaths of 35yearold Jaime Clutter, 10yearold Brandon Clutter and 6monthold Katelyn Clutter were accidental Rochford came by, grabbed her by the arm and pushed her up against the wall Think about it if you’ve spent years creating an online persona for yourself and you built a brand and a following, how scary would it be to think that someone could capitalize on your good name right on your own turf overnight?Yeah, it freaks me out a little, too – Cheap Jerseys China “I had this plan for about three months All we can tell you is trousers go on your legs and a jumper or ablouse will cover your boobs and you should put some shoes on So serious reading largely went by the wayside, and we only now emerging : , Calvin Klein Men’s Big and Tall Big 2 Pack Brief U328046 Rated ROf course, it was kind of funny when Bubl sympathized with all the men in the audience who had been dragged there, telling them that they were still masculine It is also simpler to set up yourself within the manner industry if a business is acknowledged for michael kors outlet one sort of item, instead of several goods

    Yi Zhang

    Hi Tri,

    Do you see the same message with query other than select * from the table?


    Tri Nguyen

    Hi Yi,

    SELECT * FROM MyTable1 returns the dataset results of the query with the last line “Time taken: n.n seconds, Fetched: N row(s)”
    Therefore the rowcount is correct, the only price is you have to make a query to know this rowcount, which could be a simple SELECT Count(1) FROM ….

    What I was referring to is the Hive log output in the console when it creates and populates a table. Can you please run the query I gave in the initial post and read the console output?


    Hi Tri,

    The metadata of the table should be updated. Have you tried hive.stats.autogather=true, and either reload the data, or run analyze table table_name compute statistics;


The forum ‘Hive / HCatalog’ is closed to new topics and replies.

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.