home.social

#hiveql — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #hiveql, aggregated by home.social.

  1. Shertson @[email protected] ·

    #hiveql #sql #apachehive
    Question: why do I lose records in my results when I try to use date_format(field_name) on a result field?

    The field in the table is a TIMESTAMP, so I used to_date(field_name) but that gives me yyyy-MM-dd and I need MM/dd/yyyy format.

    EDIT: Without date_format the records all show up. With date_format some records disappear from the results.

    #hiveql #sql #apachehive
  2. Shertson @[email protected] ·

    @ducksauz I just spent two days in #hiveql trying to figure out how to calculate number of business for given month. I'm pretty psyched!

    #hiveql