QUALIFY equivalent in HIVE / SPARK SQL
I am trying to convert a Teradata SQL query into HIVE/Spark SQL equivalent. Is there any substitute for qualify along with count
hive
Count records per year and month based on date & id
I have the following table.
SQOOP export HDFS to MYSQL db
I’m trying to export a HDFS to MYSQL database. I found various different solution but none of them worked, I even tried to remove the WINDOWS-1251 chars from the file.
How to find the desired output using hive/sql
I have a table like this
SQL split comma separated row
I have a column with a variable number of comma seperated values: somethingA,somethingB,somethingC somethingElseA, somethingElseB And I want the result to take each value, and create a row: somethingA somethingB somethingC somethingElseA somethingElseB How can I do this in SQL (MySQL)? (I’ve tried googling “implode” and “lateral view”, but those don’t seem to turn up … Read more
Hive 2.1.1 MetaException(message:Version information not found in metastore. )
I’m running Hadoop 2.7.3, MySQL 5.7.17 and Hive 2.1.1 on Ubuntu 16.04.
Sqoop: Could not load mysql driver exception
I Installed Sqoop in my local machine. Following are the config information.
select rows in sql with latest date for each ID repeated multiple times
I have a table where each ID is repeated 3 times. there is a date in front of each id in each row. I want to select entire row for each ID where date is latest. There are total 370 columns in this table i want all columns to get selected when i select that … Read more
Combine multiple rows into one space separated string
So I have 5 rows like this
Hive – Thrift – Missing version in readMessageBegin, old client?
Hello I’m trying to build a nodejs client for querying my hive database using thrift but I’m facing a strange issue … I’ve generated my nodejs client API with thrift (thrift -r --gen js:node TCLIService.thrift with TCLIService being the thrift file defining the Hive services) and now I try to connect to Hive but my OpenSession is pending … Maybe I’me not doing the right call but I don’t find anything recent on the net (every thrift / node / hive project is 4 or 5 years old). Can you take a look and tell me if I’m doing it wrong ? Thanks