python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - impala

Running Impala query from shell script

I want to write a shell script to invoke an Impala query. I want to check count of a table is 0 or not. If 0, then I need to fail the workflow. I am pretty new to shell script, any help is appreciated...
test-img

Andy

shell

impala

Votes: 0

Answers: 0

Exclude 1 or more column in Impala

can I exclude 1 or more column in Impala without specifying all the columns in table SELECT * [except columnA] FROM tableA
test-img

jbest

hadoop

impala

Votes: 0

Answers: 1

Latest Answer

Why not create a view of the data without ColumnA? Then you can just keep using the data but not have to have the column included? It would require you to list all the Columns once, but after that y...
test-img

Matt Andruff

Create a hive table using python

I am using python and I want to create a hive table. Also I want that table should be created with same data type as of data type in dataframe; Below is the code I used to create a connection with hiv...
test-img

KMittal

python

hive

pyodbc

impala

Votes: 0

Answers: 0

Row number for Unique value in column

I am joining three tables finally I get out three columns - with app_id, tenant_id, count_device. I have an issue with the db here for some of the app_id, tenand_id is missing, but its of the same ten...
test-img

7katana

sql

impala

row-number

Votes: 0

Answers: 1

Latest Answer

Use dense_rank, it will assign the same rank to rows with the same orderby value: with mytable as( select 'appid1' App_id, 'Tenant 1' tenant_id, 100 count_device union all select 'appid2', 'Tenant 2',...
test-img

leftjoin

Posts

Questions

Blogs

Jobs