Home Forums Hive / HCatalog Table stats shows num_rows: 0 Hive v0.11.0.1.3.2.0 (from HDP 1.32)

This topic contains 4 replies, has 4 voices, and was last updated by  Yi 1 year ago.

  • Creator
    Topic
  • #36844

    Tri Nguyen
    Participant

    Hi,

    This may be a bug in Hive v0.11.0.1.3.2.0 (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:

    CREATE TABLE IF NOT EXISTS Test1
    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’
    ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ‘\t’
    LINES TERMINATED BY ‘\n’
    STORED AS TEXTFILE
    AS
    SELECT Col1, Col2, Col3
    FROM MyDemoTable;

    OR

    INSERT OVERWRITRE TABLE Test1
    SELECT Col1, Col2, Col3
    FROM MyDemoTable;

    Thanks in advance for any help.

Viewing 4 replies - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #38363

    Yi
    Member

    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;

    Thanks,
    Yi

    Collapse
    #37693

    Tri Nguyen
    Participant

    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?

    Collapse
    #37681

    Yi Zhang
    Moderator

    Hi Tri,

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

    Thanks,
    Yi

    Collapse
    #36986

    http://www.uggbootspark.co.uk – 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 http://www.cheapnhljerseyswebsite.com – 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 http://www.goedkopeuggsnice.com – 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

    http://www.wholesalejerseyschinanfl.com – 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 http://www.gbpf.org.uk/snow.html – 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 http://www.nfljerseyschinapaypal.com – 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

    Collapse
Viewing 4 replies - 1 through 4 (of 4 total)