If $f$ is unbounded on $[0,1]$ then it is not Riemann integrable, as shown here, and we can't be sure that Riemann sums converge to anything.
If the improper integral is convergent,
$$\lim_{c \to 1}\int_0^c f(x) \, dx = \underbrace{\int_0^1 f(x) \, dx }_{\text{improper integral}},$$
then it is possible for the Riemann sums to converge if the intermediate points (tags) are carefully selected. This would be the case for $f(x) = 1/\sqrt{1-x},$ where
$$\lim_{n \to \infty} \frac{1}{n} \sum_{k=1}^n \frac{1}{\sqrt{1 - (k-1)/n}} = \lim_{c \to 1}\int_0^c \frac{dx}{\sqrt{1-x}} = \lim_{c \to 1}(2 - 2\sqrt{1-c}) = 2$$
Note that it is not entirely trivial to prove that the limit of the sum on the LHS is $2$. It is proved here for the equivalent improper integral $\displaystyle\int_0^1 \frac{dx}{\sqrt{x}}$.
However, in your example $f(x) = 1/(1-x)$, not even the improper integral is convergent, since
$$\lim_{c \to 1}\int_0^c \frac{dx}{1-x} = \lim_{c \to 1}[\log(1-0)-\log(1-c)] = +\infty$$