Simple Sql Query Doubt

[SUbba LIngam]

joke ga ana ne gussa kaku

 

nenu ekkada serious ayyaa bhayya  

[Iphone6]

Ltt simple annadu 5 pages aina res olve kaleda....sql babas help him

[tejak123]

resolved... :)

 

 

 

create table table2 as

select category id from table_name like '^[0-9]';

 

SELECT user FROM table_name  WHERE user NOT IN (SELECT user FROM table_2);

[faf]

resolved... :)

 

 

 

create table table2 as

select category id from table_name like '^[0-9]';

 

SELECT user FROM table_name  WHERE user NOT IN (SELECT user FROM table_2);

 

Ila ayite everytime new data vachinappudu nuvvu table lo ki data load cheyyalsi untadi,, use view instead.. or follow below logic.

 

CREATE TABLE test1
  ( user_name               VARCHAR2(1),
    PRODUCT_BOUGHT_CATEGORY VARCHAR2(10) );

SELECT *
FROM TEST1;
    
A    YUI
B    JHI
C    WER
E    123
A    456
C    DFG
B    CFT
E    365
S    ASD
H    HJK
E    ASD    
 
SELECT DISTINCT user_name
FROM test1 all_data
WHERE EXISTS
  (SELECT 1
      FROM
          (SELECT *
          FROM test1
          WHERE REGEXP_LIKE(PRODUCT_BOUGHT_CATEGORY, '[[:alpha:]]')
          ) alpha_prod
      WHERE all_data.user_name = alpha_prod.user_name
    )
AND NOT EXISTS
    (SELECT 1
        FROM
          (SELECT *
          FROM test1
          WHERE REGEXP_LIKE(PRODUCT_BOUGHT_CATEGORY, '[[:digit:]]')
          ) num_prod
      WHERE all_data.user_name=num_prod.user_name
    )
ORDER BY user_name

[puli_keka]

resolved... :)

 

 

 

create table table2 as

select category id from table_name like '^[0-9]';

 

SELECT user FROM table_name  WHERE user NOT IN (SELECT user FROM table_2);

 

sql azure lo new table create cheyakundane work ayyindhi.. why you had to create a new table?  any restrictions in HDInsight ?

[tejak123]

Ila ayite everytime new data vachinappudu nuvvu table lo ki data load cheyyalsi untadi,, use view instead.. or follow below logic.

 

CREATE TABLE test1
  ( user_name               VARCHAR2(1),
    PRODUCT_BOUGHT_CATEGORY VARCHAR2(10) );

SELECT *
FROM TEST1;
    
A    YUI
B    JHI
C    WER
E    123
A    456
C    DFG
B    CFT
E    365
S    ASD
H    HJK
E    ASD    
 
SELECT DISTINCT user_name
FROM test1 all_data
WHERE EXISTS
  (SELECT 1
      FROM
          (SELECT *
          FROM test1
          WHERE REGEXP_LIKE(PRODUCT_BOUGHT_CATEGORY, '[[:alpha:]]')
          ) alpha_prod
      WHERE all_data.user_name = alpha_prod.user_name
    )
AND NOT EXISTS
    (SELECT 1
        FROM
          (SELECT *
          FROM test1
          WHERE REGEXP_LIKE(PRODUCT_BOUGHT_CATEGORY, '[[:digit:]]')
          ) num_prod
      WHERE all_data.user_name=num_prod.user_name
    )
ORDER BY user_name

..//

 

 

 

yes bhaiya.. View eh vaadathanu

[tejak123]

sql azure lo new table create cheyakundane work ayyindhi.. why you had to create a new table?  any restrictions in HDInsight ?

./// NEnu azure environment bhaiya.. but i work on had0000p installed on HDINSi8 clusters... Hyve query language vaadathanu.. HIVE CLI paina

[tejak123]

thanks annayalu... without your help i wouldnt have able to swim alone... thanks guys