Home > other >  Can hive data loading, but a select statement caton has great god see online help
Can hive data loading, but a select statement caton has great god see online help

Time:09-22

Can hive data loading, but a select statement caton
What a great god online help see

Hive> The LOAD DATA LOCAL INPATH '/home/hadoop/upload/SogouQ2. TXT' INTO TABLE SogouQ2;
Copying the data from the file:/home/hadoop/upload/SogouQ2. TXT
Copying the file: file:/home/hadoop/upload/SogouQ2. TXT
Loading data to the table hive. Sogouq2
Table hive. Sogouq2 stats: [numFiles=2, numRows=0, totalSize=326191991, rawDataSize=0]
OK
The Time seems: 9.264 seconds
Hive> Select count (*) from SOGOUQ2;
The Total jobs=1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the business, the load for a reducer (In bytes) :
Set hive. The exec. Reducers) bytes) per. Reducer=& lt; Number>
In order to limit the maximum number of reducers:
The set hive. The exec. Reducers. Max=& lt; Number>
In order to set a constant number of reducers:
The set graphs. Job. Reduces=& lt; Number>

CodePudding user response:

didn't see what's the problem, are you out of the hive to understand for the database?

CodePudding user response:

Can put the queue priority setting ""?
  • Related